Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Binary to String for SQL Update
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Convert Binary to String for SQL Update
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01524435
Message ID:
01524443
Views:
49
Thank you. However I need to convert the string into a format like "003FAC23E0C46D413200", store in lcPersonID, display in a text field on a form, then eventually use that string in the SQLQuery String to update another table using "Update Table2 Set PersonID = CAST(0x" + lcPersonID + " AS Binary)"

Thanks!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform