dickylam
IS-IT--Management
- Jun 24, 2001
- 86
Hi,
Please help. I am using VFP as front end and use MS-SQL 2000 as back end database.
Basically by using sqlexecute command provided by VFP I can communicate with MS-SQL successfully.
However, I found that if I use insert, update command, the datatype seems to be character only. THerefore, some functions I can run, they are:-
newid()
datetime()
cast()
Is anybody knowing how to send t-sql command or functions ? Do I need to convert all variables into character type before ?
The value returned by newid() is a uniqueidentifier datatype.
Please help. I am using VFP as front end and use MS-SQL 2000 as back end database.
Basically by using sqlexecute command provided by VFP I can communicate with MS-SQL successfully.
However, I found that if I use insert, update command, the datatype seems to be character only. THerefore, some functions I can run, they are:-
newid()
datetime()
cast()
Is anybody knowing how to send t-sql command or functions ? Do I need to convert all variables into character type before ?
The value returned by newid() is a uniqueidentifier datatype.