NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: kevin plummer on April 15, 2015, 06:04:16 AM

Title: Signature
Post by: kevin plummer on April 15, 2015, 06:04:16 AM

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

Title: Re: Signature
Post by: debraballenger on April 15, 2015, 07:48:17 AM

Hi Kevin,

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

HTH

Debra

Title: Re: Signature
Post by: peterH on April 15, 2015, 11:16:32 AM

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

Title: Re: Signature
Post by: debraballenger on April 15, 2015, 12:36:05 PM

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

Title: Re: Signature
Post by: kevin plummer on April 15, 2015, 03:36:25 PM

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

Title: Re: Signature
Post by: debraballenger on April 15, 2015, 04:06:33 PM

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.

Title: Re: Signature
Post by: kevin plummer on April 15, 2015, 09:13:08 PM

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.

Title: Re: Signature
Post by: kevin plummer on April 28, 2015, 10:33:45 PM

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]