Zeoslib Portal

I Think the easiest way to avoid this would modify column song to varchar2(120). You know, with varchar2 only the "filled" amount of space is occupied, nothing is wasted.

hth
Rüdiger

Hm, as read commited is the default isolation level for Oracle, also for updating transactions, that doesn't sound too good. Has it always been this way?
Anyway, maybe it would be good to use a TZQuery with an to re-set it to that after connecting.

What makes me suspicious is this "type variant" in your first error message, although it is integer, as if it is not recognized where it belongs to. Did you define persistent TFields, by double clicking on the table or query icon on the form and selecting "add all fields" after r...

Hi Bill,

This normally points to that there is an older version of a bpl (in this case ZCore.bpl) somewhere on the search path. Make sure that you delete (or better, move to some unreachable place) all older Zeos libraries.

Regards,
Rüdiger

You only need TZUpdateSQL if your query is so complicated (joins) that Zeos can't generate an update sql by itself. Then you have to write your own insert/update/delete SQL in TZUpdateSQL. And yes, you have to set RequestLive = true (in 6.5.1: ReadOnly = false), for else it is in fact readonly. Rega...

Hi! It's very easy. As you wrote in the subject, it's last_insert_id(). Use a new ZReadOnlyQuery with the SQL 'select last_insert_id() as LID'. After you have done a Post and ApplyUpdates (I'm not sure if the last one is really necessary) of your Insert, close and open the LID query. Then you have t...

For Delphi's Tdatetime 31/12/1899 is just zero (you remember, digits in front of decimal separator: date, behind decimal separator: time). What's the "starting point" (zero) for PostgreSQL? Maybe 0001-12-30 BC? That would mean that the value gets lost on the way to the database. I remember...

...or maybe Oracle Express

Well, the wizard is a wizard and should know...
I think it's always SQLOLEDB.1, but I'm not sure, it's a long time since I have done that. Anyways, it has to be done on your clients' machines too, so you will see what happens.

Regards,
Rüdiger

Hi,

I suppose the odbc data source does exist? (ODBC-Datenquellen-Administrator - System-DSN or Datei-DSN) I had exactly the same error message one of these days when I tried to open an old program relying on an odbc data source which had long gone.

Regards,
Rüdiger

Ah, of course, the old BLOB problem... But then I don't think it works for other Oracle versions => 8i. Never tried it with Zeos.

No, I mean, what is ZQuery1.SQL?

As far as I can see: you hava a database field called "Description" and a Memo field with the same name, and you try to fill the database field with the contents of the memo field, using stream MS. But I don't see where you actually fill the database field. No T.FieldValues['Description']....

@Byungho:
What is your SQL?

Regards,
Rüdiger

Hello!

What do you think has to be done especially? I made a simple test (a table, a dbgrid) and this worked.