Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help on SQL To VFP Please!!!
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00681474
Message ID:
00682236
Views:
32
>>>Okay, hello and thanks in advance. I have a bit of a problem here, on a time crunch. I have a valid connection and loadout from an SQL data source, into a VFP cursor. Eventually, to dump into a database, but right now, just to list a report of certain key data items of the SQL source. However, one of the KEY data items, which needs to be reported, displayed is an SQL field, binary, contained in a memo field (aahhh!!!!).
>>>Ric
>>
>>Hi, It seems for me that you are not using the right commend, but it all depends of the way you will use that data
>>Tell me what will you do with that field, so I could try any commands to convert data in appropriate format
>
>Hello Venelina,
>
>Good to chat with you again. This field has a numeric key in binary form, it will be used once it gets into the cursor (see the code sample) to compare against the VFP table key field... new data added, existing data updated...
>
>R

Hi Ric,
I hadn't strike with any similar problems, so I think I could not help you.
But you set that you are using BINTOC(). If the data is in binary format shouldn't you use CTOBIN to obtain the numeric value? I'm not sure I understand you real need.
Anyway glad to talk with you!
Venelina Jordanova

Outsourcing IT Services Ltd.
Previous
Reply
Map
View

Click here to load this message in the networking platform