Varbinary key in tables

[vfp4ever]

Hello,

I am trying to connect to a local data source:

[tt]lnHandle = SQLSTRINGCONNECT( "Driver={Microsoft Visual FoxPro Driver}; UID=; PWD=; SourceDB=ex_database.dbc; SourceType=DBC; Exclusive=No; BackgroundFetch=No; Collate=Machine; Deleted=Yes; Null=No" )
SQLEXEC( lnHandle, "SELECT * FROM ex_table", "ex_cursor", laCount )
SQLDISCONNECT( lnHandle )
[/tt]
Everything works fine as long as I have an Integer key in ex_table, but when I change it to Varbinary type SQLEXEC refuses to work and returns a "Not a table" error. What do I have to do in order to use a Varbinary field in my table?

Regards,
Dario

 

[vfp4ever]

Thanks, Tamar

it's always a great pleasure to read your articles. Perhaps also my last chance to learn Sudoku, too.

Dario

 

[Mike Lewis]

Perhaps also my last chance to learn Sudoku, too

I've recently been trying to write a VFP program to create Killer Sudoku puzzles. Killer Sudoku is much more difficult than the standard kind. I am doing this program purely for recreation. But it still makes good use of business objects.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[TamarGranor]

Years ago, I created classes to model a deck of cards, including shuffling and dealing the solitaire version that I learned as Patience, but Microsoft calls Klondike. My goal (which I never got around to) was to test a couple of different strategies for playing.

Tamar