IT SOLUTIONS
Your full service technology partner! 
Moet [Unspecified] -Collapse +Expand
-Collapse +Expand
Moet
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (16)

Search Moet:

Advanced
Personal Account . . .
Moet
-- USA



Real Name:  Moet [Unspecified]
Primary Role:  Coder
Joined: Apr 2006 (16 years ago)
Visits: 17

Message Boards Activity

16 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

Moet
RE: Writing from Paradox to SQL Server 2005
For some reason you have to specify the time before the date therefore correct syntax is  t1."LeadDate" = string(time()) + " " + string(today())  Jon
14 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

Moet
Writing from Paradox to SQL Server 2005
Hi,  have managed to connect to Remote SQL Server 2005 table using Paradox BDE and insert records into a table using ObjectPAL.  Just have a quick question regarding the DateTime format in MSSQL  Code is as follows:-  t1."LeadDate" = string(string(today()) + " " + string(time()))  I'm getting Bad Seconds Specifiation. If I take the above code and put it in a string and copy to clipboard and paste directly into a SQL table it accepts it. I've tried all sorts of combinations but cannot get it to work using a script. I MUST have both the date and time populated.  Any help appreciated  Thanks Jon
15 years ago

Moet
For some reason you have to specify the time before the date therefore correct syntax is  t1."LeadDate" = string(time()) + " " + string(today())  Jon
14 years ago
Nothing New Since Your Last Visit
6061
Hits

Corel Paradox / ObjectPAL Coding

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

Moet
RE: Using COM class in Paradox v9
Chomp,  I've sent you a Private Message. If anyone else is reading this and wants to help you can download a 30 day trial of MatchIT API from www.helpit.com Jon
Posted to MB Topic: ObjectPAL « Paradox Board
15 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

Moet
Using COM class in Paradox v9
Hi,  Is it possible to use a COM class in Paradox (we run v9)? A supplier used to provide an ActiveX object which we dropped an a form and initalised. Their new product just uses a 'simple COM class'. They quote a VB example of initialising the object "for example, in VB you'd just add a 'Dim findit As New matchIT.findIT' line to create the object" How do I go about declaring this in Paradox? The DLL is installed C:\Program Files\matchIT API\matchIT.dll  I've never used a COM object in Paradox but have used several ActiveX objects.... Any help appreciated  Jon
Posted to MB Topic: ObjectPAL « Paradox Board
15 years ago

Moet
Chomp,  I've sent you a Private Message. If anyone else is reading this and wants to help you can download a 30 day trial of MatchIT API from www.helpit.com Jon
15 years ago
Nothing New Since Your Last Visit
2962
Hits

Corel Paradox / ObjectPAL Coding
More...
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]