Cita:
Iniciado por meru-kun Prueba con plato_dia=True .
Los boolean son 0/1 , False/True (creo xD)
Ocurre que, creo, access puede interpretar el True/False erróneamente dependiendo de la configuración regional. Por eso es conveniente usar los valores numéricos. Además, si debés migrar la base de datos a SQLServer, luego debés modificarlo. Leete este estracto de
What are the main differences between Access and SQL Server? (aspfaq.com) Cita: Switching from Yes/No to BIT In Access, you could use integers or TRUE/FALSE keywords to determine the value of the column.
In SQL Server, and especially during migration, you should use integer values only. So here are some sample queries;
note that the SQL Server queries will work Access as well.
-- DETERMINING TRUE
-- Access:
[...] WHERE ynColumn = TRUE
[...] WHERE ynColumn =
-1 (pues si, era -1
)
-- SQL Server:
[...] WHERE ynColumn <> 0
------------------------------
-- DETERMINING FALSE
-- Access:
[...] WHERE ynColumn = FALSE
[...] WHERE ynColumn = 0
-- SQL Server:
[...] WHERE ynColumn = 0
Saludos