Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to delimit a GUID in a SQLEXEC statement
Message
From
05/05/2004 19:25:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to delimit a GUID in a SQLEXEC statement
Miscellaneous
Thread ID:
00901407
Message ID:
00901407
Views:
55
I use SQL GUID's as keys on my SQL tables. I am getting the GUID for a record and going to look for other records in a different table with that GUID. My statement is
SELECT dlID2, dlID1, dlLTID, 2, 0 AS Processed  FROM DataLink WHERE  dlID1 = 'BE63E413-CD51-4D89-8D17-AF79829F'
No matter what character I use for delimiters, I can't seem to build the statement for the VFP SQLEXEC so it works. I tried the statement on the SQL Query Analyzer and the error I get is
Server: Msg 8169, Level 16, State 2, Line 6
Syntax error converting from a character string to uniqueidentifier.
Thanks,
Margaret
Next
Reply
Map
View

Click here to load this message in the networking platform