Eclipse DevSoft
Jan 7th, 2000, 06:29 PM
In MS SQL, you treat GUID as string so the SQL statement below will work:
"SELECT * FROM MyTable WHERE rowguid = '{8367BB02-D6EA-20E4-0194-1091B8F387CA}'"
If you are using an Access Database, the statement above will not work (won't return any record). How would you translate the above statement to work in an Access? In short, how would you treat GUID (Replication ID) in access?
"SELECT * FROM MyTable WHERE rowguid = '{8367BB02-D6EA-20E4-0194-1091B8F387CA}'"
If you are using an Access Database, the statement above will not work (won't return any record). How would you translate the above statement to work in an Access? In short, how would you treat GUID (Replication ID) in access?