Re: forms and native SQL

Hello Ocke,

thanks for your hints but you don't make me happy because I need to do date=
 and time arithmetics and that is nothing I can do with standard SQL (whate=
ver this is) afaik.
My problem is that I decided to use unix epoc as timestamps in my sqlite db=
 because it needs much lesser space than i.e. "YYYY-MM-DD HH:MM:SS". I do a=
 lot of logging so I gain much space by using epoc.

greetings (to hamburg?) from elmshorn
Oliver

-----Urspr=C3=BCngliche Nachricht-----
Von: "Ocke Janssen" <[email protected]>
Gesendet: 12.11.2010 09:51:27
An: [email protected]
Betreff: Re: [dba-users] forms and native SQL

>Moin Oliver,
>
>On 11.11.2010 23:52, Oliver Peters wrote:
>> Hello,
>>
>> I'm working with sqlite 3.7.3 as an external db via ODBC
>> (http://www.ch-werner.de/sqliteodbc/) under WinXP.
>>
>> My frontend is OOo Base (330 RC4). For inserting and updating tables I
>> use forms. If I choose SQL as a datasource for the form and don't allow
>> OOo to check the SQL (because I use sqlite specific constructs) I can't
>> insert or update anymore. The same with "ordinary" queries. I feel(!)
>> that this is a wanted behaviour that is reproducable with other dbs
>> (PostgreSQL, MySQL,...) but I can't explain why this should be
>> necessary.
>>
>> Any hints/coaching are/is appreciated.
>The reason is that we need to uniquely identify a row. This is done by=20
>fetching the primary key column(s). When we now can't parse the SQL=20
>statement how should we know that all primary key column(s) are part of=20
>the select. And how they are named. As work around I would try to=20
>convert the sqlite specific constructs to standard SQL where possible.
>
>Best regards,
>
>Ocke
>>
>> Oliver
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [email protected]
>For additional commands, e-mail: [email protected]
>
___________________________________________________________
Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief! =20
Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02