Macro Vs. Code (SQL)

[DCrake]

Not wishing to go over alot of what has been discussed I would like to introduce you to a smal but interesting demo I put together a while back. The basic principle it to gnerate queries/reports based on criteria entered by the user on a given form.

Instead of the normal aporach of referring to the control on the form directly from the query/report an intervening function, alogn with public variables asre used to greatly enhance the flexiblility of an application. If you select all attachments and read the documentation first it will give you an oversight into using several objects/functions/variables together into one senerio.


Best wishes

David
Click here

 

[DavidVDT]

Olav Said,
"Look at a variable as a box, or a container and the data as an item. If you want to keep ..........", This I can Very Easly understand the entire concept.
This is VERY Helpful, Thanks

I am VERY Thankful for ALL your input and feed backw/ Great examples and direction.

 

[DavidVDT]

Hello again.

Looking for some assistance, I just installed a free version of MySQL 6.0 from this site:
http://dev.mysql.com/downloads/

I registered the product, but every time I open the Code Window (Black Window w/ the prompt) it asks for a password, I never gave one nor was I given one.

Any Ideas as how to get this program to work?

Thanks
david

 

[Olav]

Hi David,
SQL servers are secure servers. This means that you need a username and password to log in.
Try to log in with the username root and no password. If you are using this server on a network, you should set a password, and create more users. For details, see
dev.mysql.com/doc/refman/5.1/en/default-privileges.html

 

[DavidVDT]

Thank You Olav,

I did modify the setup creating an anonymous user (not requiring a password),

I started the program and it prompted me for a password again

I then just hit enter and it allowed me in, (don’t know why it prompts for the pw) .....

this may have worked the 1st time this way.

Thank You for your assistance
david

 

[Olav]

I believe the program collects the username and password before checking if they are correct.

This way, the program is unable to know if the username has a password or not.
I believe the program has a user database, and asks you to enter username and password, and checks to see if there exist a post with the two given values.
I believe the contents in your SQL-user database contain these data:
NULL, NULL
root, NULL

This means that if you log in by pressing enter (username = NULL) and entering the password as "asd", the SQL database will search for a post with the values NULL, asd.
Since this post does not exist, you are not allowed to log in.

 

[DavidVDT]

This makes good sense....

If it did not check, when and where would it detour unauthorized access....

thanks