Hi,
Is there any restrictions with databases within ER6.
I don't succed to acces datas stored in a table created with PSIDAT under ER5
The same linecode works under ER5 and not under ER6
OPEN "d\system\apps\infosaero\base.odb32 SELECT * FROM Airp ", A,a,b,c$,d$,e$,f$,g$,h,i,j$,k,l$,m,n,o,p$,q$,r$
Under ER6 I obtain snipersmile "not supported"
any help would be welcome.
Thanks
Pep's
Hi Pep's!
Your problem is that ER6 uses Unicode instead of ASCII. See the following quote from the 'Symbian OS v6.0 OPL Porting Guide':
2.3 Do I need to do any change of my ER5 data files?
Again, the simple answer is ?Yes?. Data files (e.g. database files created with CREATE) on ER5 are in the narrow (ASCII) format. This is incompatible with Unicode and all files will therefore need to be re-created under Symbian OS v6.0.
I encountered the problem when I tried to open a ER5 database on a Series 60 phone. My workaround was to write a bit of OPL code which reads a CSV textfile and creates a OPL database on the 9210 PC emulator. The resulting datafile can be read on my Nokia 3650.
Because string size is limited to 255 in OPL this only works conveniently when the lines of the CSV file are maximum 255 characters long.
HTH Martin
is this little code availavle ? (to read csv anc write to db on the emulator ?)
TIA, Gerhard