.T. into 1

[RGoldthorpe]

Is there a way of scanning through a load of logical parameters and convert .T. into "1" and .F. into "0" or a so I can stick them in to SQL server.

Open to all sugestions if this isn't the right way to go about this problem.

Thanks in Advance

Rachel

 

[Mike Gagnon]

You would have to add a numeric field and use something like

update mytable set mynewfield = iif(oldfield = .t.,1,0)

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[RGoldthorpe]

Thanks mike

 

[Mike Lewis]

Rachel,

You don't need to do this. If you send .T. or .F. to SQL Server, the ODBC driver will convert it to 1 or 0.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com