Signature

[kevin plummer]

Anyone using SQL Backend and using signatures? The example uses TPS files and field type of Memo64k but that does not exist in a SQL Table. I tried to use a Blob but I get compile errors. I tried using a local variable but again no memo and String64k did not work.

Cheers,

Kevin

[debraballenger]

Hi Kevin,

In SQL I use a varchar(max) datatype, and in Clarion a string 1650000

HTH

Debra

[peterH]

Hi Debra,

I'm curious. How did you end up with that number (1650000)? Did you do some kind of magic calculations or was it trial & error or you just made it 'big'?

Peter

[debraballenger]

I think I got that number from memo field settings from DMC.

[kevin plummer]

Hi Deb,

just to clarify, in your dictionary you define the field as String 1650000? I use FM3 to handle table changes so i'm not sure what that would reconcile to on the back end.

Cheers,

Kev

[debraballenger]

Yes that is the correct length.  I don't use fm3, but in the backend I use a varchar(max).  I think you can override fm3 though to specify the datatype.

[kevin plummer]

Thanks Deb - I couldn't get it to work so I tweaked the MSSQL example with your suggestions and sent it to Bruce for further analysis.

[kevin plummer]

Hi All,

Anyone that has got the signature working in SQL can you take a look at the modified example 73 and tell me where I have gone wrong? The example uses FM3,

Cheers,

Kevin

[attachment deleted by admin]