Database Question

[wm.chatman]

Hi Klaus

You did make a few changes, now I have to work with.
I tested the new update and sure does look real good (Datum Situation).
The best of thanks for your help. It seems to work at this stage.
Still will test more.
Also I had workt with Tables and col and thought I got the hang of things.
Trying to add a new Table > table1.AddCol (cString,"Datierung",80) and of course the rest of Propertys seems not to work now, with your new update.
Had plans on adding 1-2 more col into table.
I did pretty much gotten things figured out with the Table situation, in the other Database UI. Adding new this and that workt real nice.

so, going back to your last update, I cant seem to add a new Col to Table.
What am I missing, overlooking?

Thank you Klaus for a Q responce:sign0085:

Best regards
Bright Bulb

 

[klaus]

Trying to add a new Table > table1.AddCol (cString,"Datierung",80) .

What are you really mean with this ?
Do you want to add a new Table or do you want to add a new colum to Table1 ?

and of course the rest of Propertys seems not to work now, with your new update

What are the problems? What do you mean with "the rest of Properties" ?

If you add a new column directly in the code, you must also update the csv file. Otherwise when loading it, the program is missing this column.

Best regards.

 

[wm.chatman]

What are you really mean with this ?
Do you want to add a new Table or do you want to add a new colum to Table1 ?


What are the problems? What do you mean with "the rest of Properties" ?

If you add a new column directly in the code, you must also update the csv file. Otherwise when loading it, the program is missing this column.

Best regards.

I add a new column in the code, and did not update the csv file. That is why when loading, the program is missing this column.
other propertys I mean populating the txtBox with the new input.
Do I update csv file by saving it?

 

[klaus]

You should update the csv file with a text editor. Header and column content.

Best regards.

 

[wm.chatman]

Klaus

Ok I tried as you stated, still getting errors loading the csv.
What is missing ?

 

[wm.chatman]

guess I need to add the Century at the Line?
this is something new now.
is this the correct way?

 

[wm.chatman]

guess I need to add the Century at the Line?
this is something new now.
is this the correct way?

:sign0060: must have done it Correct!
It works Klaus.
But, is there not a possibility for a work around?

Thank you Sir for your speedy help

Best regards
William

 

[klaus]

Another way is not to read the csv file, and populate the table in the program and save the table. But I dont think that this would be faster.
A 3rd possibility is to generate the csv file with Excel, but this becomes even a bit more complicated. Because:
- the Excel csv file is saved with the ANSI code page, but B4PPC uses the UTF-8 code page.
this can become a problem when you have characters like ä, ü, é, è etc.
- the separator character is ";" and not "," and must be changed in the LoadCsv and SaveCsv statements.

Best regards.

 

[wm.chatman]

Another way is not to read the csv file, and populate the table in the program and save the table. But I dont think that this would be faster.
A 3rd possibility is to generate the csv file with Excel, but this becomes even a bit more complicated. Because:
- the Excel csv file is saved with the ANSI code page, but B4PPC uses the UTF-8 code page.
this can become a problem when you have characters like ä, ü, é, è etc.
- the separator character is ";" and not "," and must be changed in the LoadCsv and SaveCsv statements.

Best regards.

yes, I tried something different and found out that its best to use a Text Editor! so, I guess for future use, its good to know.

Danke sehr klaus
Best regards
William

 

[wm.chatman]

Klaus, its the Bright Bulb again...

added my very last Column, but now I get a error msg stating:

Lenght cannot be less than zero
Parameter name: lenght

might want to check also using Editor

Thanks
Best regards
William

 

[klaus]

Here you are.
I changed the btnAdd routine, you didn't add all elements and in a wrong order.
In the csv file you had 2 quotes ". These produced the error when loading it.

Best regards.

EDIT: removed source code

 

[wm.chatman]

Here you are.
I changed the btnAdd routine, you didn't add all elements and in a wrong order.
In the csv file you had 2 quotes ". These produced the error when loading it.

Best regards.

nims nicht krum.
du bist ein schatz

 

[wm.chatman]

Dir Klaus
:sign0060:
Now everything seems to be in working order. I like the search function you added, and you did also add some better functions to rest of the App.
sorry that I am such a Headache (stress), I am very glad that you have helpt!

Thank you very very much Klaus!

take care and stay Gesund
:sign0089:
Best regards
Bright Bulb
William

 

[klaus]

Hi William,
Here is the last version, I hope that the automatic screen orientation change will work.

Best regards.

EDIT: removed source code, new version in post#78

 

[wm.chatman]

Hi Klaus

Thank you Sir, for the help and geduld.
A Question please. How do I update latest Zip file, for new version?
Delete the Zip file, and just add the newest Zip file?

Thank you Klaus

Best regards
William

 

[klaus]

I woukd suggest to open a new folder, copy the new zip file and unzip it and work in there.
When everything is OK you can either keep the old folder or delete it.
When you load the sbp file the first time all the libraries are automatically copied in this new folder.

Best regards.

 

[wm.chatman]

Hi Klaus

Thank you for the time and help you invested again! :icon_clap:
On the Desktop the App works great, but testing on Device we have a few things missing or can only be seen part of the way. I did not forget the landscape layout change, in the IDE, the screen size from 320*240 to 240*320. Yes, I need to change a few things in the IDE in order to be shown correct on Device I know.
But, you had stated :
Before beginning coding you should determine what you want and what you need:
- do you really need or want to have both screen orientations ?
Well here is the Answer. No, we do not need both screen orientations! Think it best to stay with portait only. Oh, I am Ashamed again, after all the time and work you had invested Klaus :sign0137: (Sorry).
I will try to Update the Zip file on the Forum later. Have added a couple of items to the main Form.
Again, thank you very very much Klaus, for helping and being patient with me.
Wuensche Gesundheit und schoenes WE

Best regards
William

 

[klaus]

Hi William,

The last version has the automatic screen orientation.
Attached a newer version I tested on my Qtek 9090, made some minor changes.
You should also notice that there is a new function.
The previous Find function has become the Filter function and there is a new Find function.

Best regards.

EDIT: removed source code, new one in post #81

 

[wm.chatman]

Hi Klaus

Looks Great Klaus, tested the newest update and getting close to it. But...
For portrait we are missing the scrool bar on the left of the tbl, btnNext and lblRecords top right of frmMain, and we can not hide the tbl. No btn.

As for the landscape mode, it does not show lblArea and txtArea.
Also the scroll bar on bottom of tbl is not shown correct, cant see even half of it. Hiding the tbl shows the btnPanelUpDown btn, and this also hides part of the lblRecords, first half.
btnPanelUpDown I do not quite understand.

Klaus, would you please take a look at the Find function.
Search for France, after France has been found try the Show next record or the show previous record. We ought to be able to continue with Show next or Show Previous Record. Are unable to get out of the Find function after the data record had been found. The same problem with the Filter function we are unable to continue Show Previous or Next Record.

As for the landscape and portrait mode problem, it sure would Help if someone could Test the newest version that you had posted on the Forum on a MDA Pro. This would help very much!!! :sign0085: new version in post#78

Best regards

William

 

[klaus]

The display problems will be fixed tomorrow.
I already were replacing the scrollbar for the display panel by a button.

For the Find and Filter function, when filtering on France you get only one record and even for the Find function the program will not allow to go to the next or previous record because ther are none.
If you filter, in the Find function on Blue, you will get 3 records and you can switch to the next and previous records but only the record that were found even though the whole table is displayed, the records are displaye in green.
To release the Find and Filter function click once again on the buttons.
The Find and Filter buttons are displayed in white when the function is active.

I will test the landscape mode on my Qtek 9090, it doesn't switch automatically but I can set it. There were some problems with the scrollbar so I am replacing it by a button.

Best regards.