My understanding that SQL Server BIT servers pretty much the same purpose as VFP Logical type column. If I have a table in SQL Server with a column type BIT and a table in VFP with the column type LOGICAL (basically the same-purpose table) can I use the same SQL Select or SQL UPDATE this column?
For example, for SQL Server I would have:
update MyTable Set MyField = '122' where NewCol = 0
select * from MyTable where NewCol = 1
And for VFP the SQL commands would be:
update MyTable Set MyField = '122' where !NewCol
select * from MyTable where NewCol
Is there a way to make both cases work with the same syntax?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham