fill field Contents

[francof]

ciao all,

how can I use the Contents pane, in the property inspector of a Basic Table Field, to insert the data columns of a database respecting the order of it?

for example:

from the Db table_Ident
name. . . . .last_name
Bill. . . . . . . .The Kid
Robert. . . . . .Zimmerman


into the field
1° col. . . . .2° col
bill. . . . . . .The Kid
Robert. . . . .Zimmerman



using the icon folder button of the Contents pane, I tried to open the DB directly, also convert first the Db into a .xls or .txt file. but, obviously, it does not work.


thanks for help
franco

[Klaus]

Hi Franco,

the "table field" is just a text field and accepts TAB delimited TEXT (and text files) but you cannot connect to a database here.
So put your data into a TEXT file (TAB delimted!) and you can import it via the "folder" button in the inspector.

Of course you can put the data that you have fetched from a database directly into a "table" field via script!


Best

Klaus

[francof]

ciao Klaus, nice to meet you again.

...
Of course you can put the data that you have fetched from a database directly into a "table" field via script!


Best

Klaus

I should like but, I again fight against item delimiter
this trash:

Code: Select all

put "SELECT distillato,descrizione FROM tbldistillati order by distillato" into tQuery
 
--This will query the Database Table using the statement in tQuery
put numtochar(1) into tItemDel
put numtochar(2) into tLineDel
put revDataFromQuery(tItemDel, tLineDel, tDatabaseID, tQuery) into tDatapiatti

returm me all data into the first column of the field

best
franco

[Klaus]

Franco,

do you remember what the DEFAULT delimiters in database queries are?

We used some time to finally change it to numtochar(1 and 2) to fit your needs!
We did this because your database fields contained MULTILINE text.

If you now use a field (instead of a datagrid) you will have the SAME problems with MULTILINE text!
If not, well what is the logical conclusion to this fact? Hint, see my first sentence!


Best

Klaus

[francof]

Franco,

do you remember what the DEFAULT delimiters in database queries are?
...

TAB and CR

...

If you now use a field (instead of a datagrid) you will have the SAME problems with MULTILINE text!
If not, well what is the logical conclusion to this fact? Hint, see my first sentence!
...

do you mean to use default delimiter? no dai!
it works only with records without multi line text. I don't like make only copy-and-paste, without know that I'm doing. at present I'm so far....

ciao
franco

[Klaus]

But you now need to decide what to do!

1. So your data HAS multiline text, right?
2. TAB and CR does not work if this is the case.
3. numtochar(1/2) does also not work for a TABLE field. which is ONE field and not a lot of grouped objects like a datagrid

Can't you also use a datagrid here?
If you really need to use a TABLE field then this is possbile, but needs a lot of preparation to make the data fit!

[francof]

But you now need to decide what to do!

1. So your data HAS multiline text, right?
2. TAB and CR does not work if this is the case.
3. numtochar(1/2) does also not work for a TABLE field. which is ONE field and not a lot of grouped objects like a datagrid
...

1 yes
2 yes
3 yes: good, this is another new information for me.

...
Can't you also use a datagrid here?
If you really need to use a TABLE field then this is possbile, but needs a lot of preparation to make the data fit!

I've never used DataGrid object, not even in the other occurrence, where you explain to me the use of numtochar(1/2), I put data into a list field.

I can show what I've, the code below comes from an old version of the project I want to implement (and is not mine...)

Code: Select all

on mouseUp
       local tDatabaseID
put revOpenDatabase("ODBC", "esa", "esa", "abcd", "1234" ) into tDatabaseID

put "SELECT distillato,descrizione FROM tbldistillati order by distillato" into tQuery 
      --This will query the Database Table using the statement in tQuery
put revDataFromQuery(tab, cr, tDatabaseID, tQuery) into tDatapiatti

       --This will display all the data from the Database
put tDatapiatti into field "elenco_argomenti_risposta"

       --This closes the Database connection
revCloseDatabase tDatabaseID
end mouseUp

this code put the data into a field "elenco_argomenti_risposta" see below

Immagine.jpg (17.45 KiB) Viewed 5748 times

what I don't understand is how tab and cr delimiter they can work, the Db is another version but, the data are the same. may have been inserted in a different way: without multiline text, difficult to think.

this is what I want to do.
could fit even a Data Grid, if it is easier to use

ciao
franco

[phaworth]

You might try using revQueryDatabase instead of revDataFromQuery. It returns a cursor id instead of the actual data. You can then navigate thru the records using revMoveToxxxRecord (xxx=First/Next/Prev/Last) and revDatabaseColumnNamed to get the data from a column into a variable.

You still have to deal with return and tab characters in the data of course. I usually do that by replacing them with a string of some sort. Or you can replace return with numToChar(11) to handle return characters.

Pete

[francof]

tanks Pete for your suggestion.
I've solved, finally, changing the delimiters. here put the recordset from the query into a Table Field:

Code: Select all

put revDataFromQuery("§","|", tDatabaseID, tQuery) into tDistillati
   replace cr with " " in tDistillati
   replace tab with " " in tDistillati
   replace "§" with tab in tDistillati
   replace "|" with cr in tDistillati
   
   ---------------------This will display all the data from the Database
   put tDistillati into field "elenco_argomenti_risposta"

and below show data, divided by elements, into different text fields and labels

Code: Select all

command visualizza_risposta
   put  fld "elenco_argomenti_risposta" into tTempList
   filter tTempList with  the text of the field"txtcerca_argomento" & "*"
   
   set itemdel to tab
   
   --put tTempList into fld "txtdescrizione"
   put item 2 of tTempList into fld "txtdescrizione"
   put item 3 of tTempList into fld "lblOrigine"
end visualizza_risposta

ciao all
franco