Hey, got another question.
Are there any other database functions, like random access files for example, besides the MySQL example that comes with the download?
If there isn`t, that is one that I would add for the next version.
Mark
Database functions besides SQL
Database functions besides SQL
right now MySQL lite and Flat File are the only choices.
if you are doing something really crazy the SQL will handle it, if it is a few hundred simple records, then why not a Flat File?
it is text and can be modified without all the overhead.
if you are doing something really crazy the SQL will handle it, if it is a few hundred simple records, then why not a Flat File?
it is text and can be modified without all the overhead.
Database functions besides SQL
I am rather new to programming. Is there an example of a flat file database that I can use as a reference?
Than You for any help you can give me.
Than You for any help you can give me.
Database functions besides SQL
I`ll get so something as quick as I can, getting the final stuff on FnxDesigner gets some priority and I also used it to build an example.
Also I am having the learn all the "unique" things that FNX can do and how it can be used.
Now the serious stuff......90% planning produces 10% "do it over" but 10% planning will get 90% life in hell.
Get a good design for your data and 80% of your work is done.
The programs [use apps] can change with no problem but having restructure the DB every other month just will not work.
I have a customer that FireFox3 failed to get their HTML bookmarks and load them, thankfully you can import them.
See what I mean.
PS: long day and just remembered to say send me a DB layout and I`ll give you the basics to go on.
this is the "thought" process.
aPart = Field$(string, delimiter, index) is the magic function
Getting the delimiter is part of the design.
If you do comma [,] and set up LName,FName,Phone,Fax,Cell [Pattillo,Trey,###,###,###] then someone will surely do
Pattillo,Trey in LName or FName and you trash the DB with Pattillo,Trey,,###,###,### [notice 2 commas is now 6 fields.
I have used ~ since not much used it and having to do a shift with the key mean the user can not trash the DB just make
the data look bad [hello -- validate and scrub your data].
A ; is pretty good as only the telephone company`s will use it like Smith;John
Giving it up for tonight - only got 3 hours sleep last night and home at 9:00CDT
--Trey Pattillo
Also I am having the learn all the "unique" things that FNX can do and how it can be used.
Now the serious stuff......90% planning produces 10% "do it over" but 10% planning will get 90% life in hell.
Get a good design for your data and 80% of your work is done.
The programs [use apps] can change with no problem but having restructure the DB every other month just will not work.
I have a customer that FireFox3 failed to get their HTML bookmarks and load them, thankfully you can import them.
See what I mean.
PS: long day and just remembered to say send me a DB layout and I`ll give you the basics to go on.
this is the "thought" process.
aPart = Field$(string, delimiter, index) is the magic function
Getting the delimiter is part of the design.
If you do comma [,] and set up LName,FName,Phone,Fax,Cell [Pattillo,Trey,###,###,###] then someone will surely do
Pattillo,Trey in LName or FName and you trash the DB with Pattillo,Trey,,###,###,### [notice 2 commas is now 6 fields.
I have used ~ since not much used it and having to do a shift with the key mean the user can not trash the DB just make
the data look bad [hello -- validate and scrub your data].
A ; is pretty good as only the telephone company`s will use it like Smith;John
Giving it up for tonight - only got 3 hours sleep last night and home at 9:00CDT
--Trey Pattillo
Database functions besides SQL
Trey,
I left you a private message regarding the flat file database.
Regards,
Chip McCann
I left you a private message regarding the flat file database.
Regards,
Chip McCann