forum.vdsworld.com

Andy_Fletcher

Hi Guys,
As you know I have just started to play with the table eliment which came with Version 5.0 VDS.

I'm useing to show results of a search and get the results of my search into @text and send to the table.
Brilliant I think but when I clear the table and try to put next search into the table I only get data for first column in it rather than the whole row.

When adding a row to table I use "List assign,1 %m" and then
dialog set,table,@text(1)

When user runs another search and press the OKBUTTON
I do this "List Clear,Table

Any clues on what I'm doing wrong ?

Should I clear the Table dialog with a different command ?

jules · Posted: Thu Dec 18, 2003 6:31 pm Post subject:

This happens to me all the time. I think you have probably changed the field separator.

Try this:

Andy_Fletcher · Posted: Thu Dec 18, 2003 7:12 pm Post subject:

Ahhhhhh !!! thats it,Thank Jules I remember reading somewhere that the Table eliment uses Tabs as sepaerators is that right ?

So if I change the feild seperator to | the it will only show the first column of data and know others may be.

Funny thing is though thet this only happen after a click event is generate from the the table. i.e script goes off and does something clever then goes to Loop, then when you do you next search it does this thing with only first column of info.

Thanks for your thoughts so far I'll check my scrpt to see if Field sep is changed somewhere.

Regards
Andy Fletcher Embarassed

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

If you don't want the click event, you can clear the event buffer using the
following code:

jules · Posted: Fri Dec 19, 2003 10:03 am Post subject:

Yes, unfortunately a click event is generated whenever you add an item to the table and because VDS buffers the events, it's usually a good idea to clear the event buffer after adding data to a table.

Andy_Fletcher · Posted: Fri Dec 19, 2003 1:04 pm Post subject:

Hi Jules and VDS Team,
Your original solution worked fine and the table re poulates fine with the Option Fieldsep, comannd.

Quick question from this...

If the user clicks on a row and the script runs another VDS exe to view all data from a database. does the fact that I changed the field seperator
affect the other exe we are using as a viewer ?

I'm thinking that they are both using the same runtime engine/interpreter..

Regards
Andy Fletcher

PGWARE · **Web Host** Joined: 29 Dec 2001 Posts: 1566

Changes to any field seperators, decimalseperators etc are local to your program only. You will need to modify the decimalsep, filedsep in the other app as well within it's code.

Andy_Fletcher · Posted: Fri Dec 19, 2003 6:10 pm Post subject:

Thanks for that, I thought that was the case, In fact can't imagine an instance where it could be affected. Guess I must have changed something in the Veiwer exe and forgot about it and the script failure happening after changing the field seperator of the main program at the time the view exe faild must have been a coinsidence then.

Doh!

Cheers now.
Andy Fletcher

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

Andy_Fletcher · Posted: Tue Dec 23, 2003 11:41 am Post subject:

Apologies FF I could only see VDSWorld TEAM on the comment made and was not sure who I was addressing. Many thanks for all your help.
Have made progress in my understanding of these dialogs. and my somewhat basic programming skills.
I wander how long I should keep the tag "newbie" for. I suppose I need to have written some programs incorporating all the new elements and capabilities of VDS 5.0 first.

Regards and have a very merry Christmas to all in the team.
Andy Fletcher