• Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r4wp

[Databases] group to discuss various database issues and drivers

Kaj
4-Jul-2013
[401]
Yes, it's in progress. Some like SQLite are one-to-one in Red like 
in Red/System. SDL is used more as a part in other low level bindings, 
such as OpenGL. OpenGL itself is waiting for floats in Red
Pekr
4-Jul-2013
[402x3]
ok, so got valid ODBC connection string fro .xlsx files. R2 crashes 
when copying a data though ...

p: open [
     scheme: 'ODBC

     target: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\Work\sales.xlsx;"
]
ok, got it kind of working with the increase of p/locals/rows to 
10K lines ... the excel sheets are so complex, that it does not return 
half of the info, it most probably counts on more columnar/db kind 
of data ...
pity Saphirion's excel dialect is not available for download anymore. 
Will try with Anton's old COMlib code ...
DocKimbel
4-Jul-2013
[405]
Sorry for the off-topic question, I though I was in another channel.
Pekr
4-Jul-2013
[406]
You are used to Red channel being at the top, right? :-)
DocKimbel
4-Jul-2013
[407:last]
Just forgot to check the channel name before posting. ;-)