PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → date mask using mysql
date mask using mysql
Débuté par joe crevino, 09 mar. 2004 16:40 - 5 réponses
Posté le 09 mars 2004 - 16:40
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe
Posté le 09 mars 2004 - 23:54
Hi Joe
Why dont you create your Database with MySQL
(If it doesnt already exist) and Import it
Into WinDev (Let WinDev take care of Data Types)
Just a thought
HTH
Keep well
Peter Purton
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe
Posté le 10 mars 2004 - 14:53
Hi Peter,
The problem is there are 150 users on the current app(the one we are converting to windev). The data is currently on a Sun Solaris we are very happy with the speed etc. Converting to hyperfiles would not give us any benefit. If that is what you are suggesting.
We are accessing mysql directly.
thank you,
joe
Hi Joe
Why dont you create your Database with MySQL
(If it doesnt already exist) and Import it
Into WinDev (Let WinDev take care of Data Types)
Just a thought
HTH
Keep well
Peter Purton
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe
Posté le 10 mars 2004 - 23:10
Hi Joe
I think I read somewhere that the Date format
For SQL is {d 'YYYY-MM-DD'} with the space after
The d
EG
INSERT INTO TABLE(DATE) VALUES ({d '1999-12-25'})
With a return value of YYYYMMDD
HTH
Keep well
Peter Purton

Hi Peter,
The problem is there are 150 users on the current app(the one we are converting to windev). The data is currently on a Sun Solaris we are very happy with the speed etc. Converting to hyperfiles would not give us any benefit. If that is what you are suggesting.
We are accessing mysql directly.
thank you,
joe
Hi Joe
Why dont you create your Database with MySQL
(If it doesnt already exist) and Import it
Into WinDev (Let WinDev take care of Data Types)
Just a thought
HTH
Keep well
Peter Purton
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe
Posté le 11 mars 2004 - 17:50
Joe,
Peter is right. But forgot an important detail.
In windev you should "import" (in your analysis)
the data-structure of your MySQL-table(s).
However while doing that make sure you DO NOT CONVERT the imported data
to Hyperfiles!! So leave the "data" on the MYSQL-database.
That way you get in your analysis table-descriptions matching
the MySQL-tables-descriptions plus, if connected, to the MySQL-Server/Database you can access the data itself, Read/write whatever.
The Actual data REMAIN on your MySQL-Tables.
More, in the same analysis, you can have aside the MySQL-tables your own
Hyperfiles and read + write from one into the other type.
(with simple HRead.../HWrite statements)
Now:
A couple of simple HRead...statements (within a simple Windev-program)
on those connected MySQL-Tabls-data will show you immedeately
the lay-out of the date-fields....
One important detail:
If ever the MySQL-tables "change" in structure,
you will have "synchronise" your Windev-analysis.
Beware of changes that might trouble your Windev-programs
(Fields or keys that were "changed" or "deleted" in the structures!)
Have Fun!
Lieven De Nys,
Member of the Dutch-speaking Benelux-Windevgroup.
Hi Peter,
The problem is there are 150 users on the current app(the one we are converting to windev). The data is currently on a Sun Solaris we are very happy with the speed etc. Converting to hyperfiles would not give us any benefit. If that is what you are suggesting.
We are accessing mysql directly.
thank you,
joe
Hi Joe
Why dont you create your Database with MySQL
(If it doesnt already exist) and Import it
Into WinDev (Let WinDev take care of Data Types)
Just a thought
HTH
Keep well
Peter Purton
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe
Posté le 11 mars 2004 - 23:24
Joe,
Peter is right. But forgot an important detail.
In windev you should "import" (in your analysis)
the data-structure of your MySQL-table(s).
However while doing that make sure you DO NOT CONVERT the imported data
to Hyperfiles!! So leave the "data" on the MYSQL-database.
That way you get in your analysis table-descriptions matching
the MySQL-tables-descriptions plus, if connected, to the MySQL-Server/Database you can access the data itself, Read/write whatever.
The Actual data REMAIN on your MySQL-Tables.
More, in the same analysis, you can have aside the MySQL-tables your own
Hyperfiles and read + write from one into the other type.
(with simple HRead.../HWrite statements)
Now:
A couple of simple HRead...statements (within a simple Windev-program)
on those connected MySQL-Tabls-data will show you immedeately
the lay-out of the date-fields....
One important detail:
If ever the MySQL-tables "change" in structure,
you will have "synchronise" your Windev-analysis.
Beware of changes that might trouble your Windev-programs
(Fields or keys that were "changed" or "deleted" in the structures!)
Have Fun!
Lieven De Nys,
Member of the Dutch-speaking Benelux-Windevgroup.
Hi Peter,
The problem is there are 150 users on the current app(the one we are converting to windev). The data is currently on a Sun Solaris we are very happy with the speed etc. Converting to hyperfiles would not give us any benefit. If that is what you are suggesting.
We are accessing mysql directly.
thank you,
joe
Hi Joe
Why dont you create your Database with MySQL
(If it doesnt already exist) and Import it
Into WinDev (Let WinDev take care of Data Types)
Just a thought
HTH
Keep well
Peter Purton
What is the proper mask choice in a table control using mysql. I can not seem to get this right.
thank you,
joe