Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

help on rebol-cmd ODBC getting fieldnames

 [1/6] from: sags::apollo::lv at: 8-Oct-2005 18:32

Hi, Rebolers! I was unable to google the subj. ;-) Could somebody please help me with an advice? In php I like better to work with associative arrays and I want to do something similar in Rebol. brgds Janeks

 [2/6] from: lmecir:mbox:vol:cz at: 7-Oct-2005 17:57

[sags--apollo--lv] napsal(a):
>Hi, Rebolers! > I was unable to google the subj.
<<quoted lines omitted: 4>>
>brgds >Janeks -L

 [3/6] from: sags::apollo::lv at: 12-Oct-2005 22:39

To be more exact I need to get field/column names from a query. In there are described getting of field/column names from a table - but I need from query. At least for MS-SQL it did not work. Any hints? Janeks On 8 Oct 2005 at 18:32, [sags--apollo--lv] wrote:

 [4/6] from: SunandaDH::aol::com at: 13-Oct-2005 3:16

> At least for MS-SQL it did not work. > Any hints?
As it says, it is a database specific method. Take a look at the message here (and the next one that adds a correction):,33446,34909#msg-34909 I don't use MySQL myself so I can't say if it works, but it looks plausible, Sunanda

 [5/6] from: mike::yaunish::shaw::ca at: 13-Oct-2005 9:44

In MySQL I use the query "SHOW COLUMNS FROM <tablename>" Mike

 [6/6] from: sags::apollo::lv at: 15-Oct-2005 23:42

It is not problem to get field names from a table. And it if its not possible to do directly in Rebol than it is possibel in SQL. The problem in details: Example a query: select t1.fld1 "name", t1.fld3 "param1", t2.fld1 "param2" from t1, t2 where t1.fld1 = t2.fld2 How to get in Rebol a block or object of the query above field names f.ex. like this: [ "name" "param1" "param2" ] Thanks in advance, Janeks On 13 Oct 2005 at 9:44, Mike Yaunish wrote:

  • Quoted lines have been omitted from some messages.
    View the message alone to see the lines that have been omitted