In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

Cannot set lOpen to T or .T.

Xailer professional forum in English
Responder
DC
Mensajes: 122
Registrado: Lun May 16, 2011 6:06 pm

Cannot set lOpen to T or .T.

Mensaje por DC »

Xailer_ConnectToSqliteTable.jpg
Xailer_ConnectToSqliteTable.jpg (100.34 KiB) Visto 765 veces
Hi,

I cannot set up a DbBrowse with a Sqlite database.

The SqliteDataSource is set correctly and connected (lConnected := .T.)


But after I assign the datasource to oDataSource in a TSqlQuery or TSqlTable, Xailer won't let me assign .T. to lOpen.

It doesn't matter whether I type in .T. or T, or use the picklist at lOpen to select T. Either way, it just reassigns it to .T..

Also, the first time I tried to assign T, Xailer showed me a warning that

Sqlite Error: #1 near "." : syntax error.

Maybe that is related to using .T. instead of T. But I tried both.
Adjuntos
SqliteTest1.zip
(2.21 KiB) Descargado 51 veces
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9253
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Re: Cannot set lOpen to T or .T.

Mensaje por ignacio »

Hi,

<<< cSelect >>> must be set.

Regards
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
DC
Mensajes: 122
Registrado: Lun May 16, 2011 6:06 pm

Re: Cannot set lOpen to T or .T.

Mensaje por DC »

Thanks, that works. Sorry for these dumb questions, but most of my job over the past 5-6 years has been scripting. I don't deal with a lot of forms, other than editing some html.
ignacio escribió: Jue Ago 24, 2023 10:18 am Hi,

<<< cSelect >>> must be set.

Regards
Responder