Recent content by Jan

Thanks guys. It was the character set setting. Everything works fine now. Rgds Jan

Hi Forum. Today our sysdba's moved from oracle 8 to 9i, and suddenly my applications doesn't work. I tried to hook up a small app. with an OracleConnection, OracleDataset,a datasource and a DBgrid (3.4.6.1) I can connect to the database, but if i make a simple query (select * from atable) i...

Hi Marco. That is exactly what i am looking for. Thanks Jan

Hi all. How do i copy a record with all its fields ? I want to make an exact copy except for a unique field "ID" which is updated by a sequence - controlled by TOracleDataset Sequencefield. I want to get the ID of the new record returned immediately after the copy. Rgds Jan

Hello. How do i make TOracleDataset use the systems date settings ? All dates are displayed as dd-MMM-yy (as set in Control Panel/Regional Settings) but when i enter a date (ie. 03-Jan-01) i get "03-Jan-01 is not a valid date and time" If i enter a date as 03-01-01 it is accepted and changed...

Ok - so i only have to change it where i use UID as a parameter name. Thanks for your fast reply Jan

Hi everyone. I have a problem setting variable names in DOA TOracleDataset (its a part of at Select statement) : DQry.SQL.Add('Where INITIALER=:UID))'); DQry.DeclareVariable('UID',OtString); DQry.SetVariable('UID','XXXX'); Here i set a variable called UID which causes the error message...