Zeoslib Portal

OK, I found the problem. Worked perfectly.

Thanks a stack for all the help.

OK, I managed to get all the connections working. I can login, if I drop a dbgrid onto the form, I can see the table contents, BUT . . .

I get an error message that the field ID doesn't exist when I try to execute the query.

I think I'm getting too old for this!

Fantastic! That was all that I wanted (I thought), but now the next problem rears its head. I have two TDatasource one omovie the other nmovie I have two TZConnection one oldmov the other newmov I have two TZQuery one Omovquery the other Nmovquery Omovie Dataset is Omovquery Nmovie Dataset is Nmovqu...

I'm using Delphi XE3 and the latest Zeoslib. Here's my problem : - I retired 6 years ago and haven't used Delphi in anger since then, so I'm a bit rusty (this year's understatement!) I have three MySQL Databases that have been written by various members of the family over the years. One holds TV-Ser...

I wasn't trying to be rude. As I said, I'm not senile even though I am 72 and I check EVERYTHING line by line and add watches and breaks everywhere. I'm obviously one up on you, because I DID manage to create the Tables, the Constraints and everything using INNODB and MySQL As I said if you put the ...

Thanks for the snippets but . . . Snippet 1. Tells me that there is no Field COUNTX. This is my Table Fsql:='CREATE TABLE types ( ' + ' typeid int(10) NOT NULL AUTO_INCREMENT,' + ' name varchar(60) NULL DEFAULT NULL,' + ' recipes_recipeid INT(10) NOT NULL,' + ' PRIMARY KEY (typeid),' + ' UNIQUE INDE...

I am not completely senile, I already tried it without the commas. Perhaps if you tried it yourself, you would find that it DOES NOT WORK if you try to split the line up and if you spotted it from the very beginning, why didn't you point it out?

No problem. Create database as normal. Create Tables, Primary Keys and Indexes as normal Now use Alter Table to create the Constraints etc, BUT . . . It only works if you put the CONSTRAINT FOREIGN KEY REFERENCES and ON UPDATE and ON DELETE all on one single line. I tried every way possible to split...

No, that wasn't the problem, it was something that I'm actually amazed that no-one picked up on. It makes me wonder if other people actually use MySQL, not only with ZeosLib, but with Delphi at all, because in 3 different Forums, not a single person could point me in the right direction, I spent MAN...

If I execute a query i.e. Nsql := ' SELECT COUNT(DISTINCT types.typeid) FROM types;'; How can I store the result into a Variable? If I have a number of Items in a Table as varchar(45) and I execute a query such as ' SELECT types.myType FROM types;'; How can I store all the results into an Array[0..1...

Thanks for all the help. I managed to Create the database, Create all the tables, Indexes, Constraints, References. Foreign Keys etc. at Runtime. I spent a lot of time trying to work this out, but I finally got it all working. NOT easy!

Now for the next problem . . .

I got all excited. I thought this was the problem, so I created the Recipe Table, then the Ingredients Table then the Type Table and finally the RecipeIngredients Table. (I took out all the CONSTRAINT fk_types_recipe1,' + ' FOREIGN KEY (recipe_recipeid),' + ' REFERENCES recipe (recipeid),' + ' ON DE...

I'm trying to create 4 tables. I set the tables up with MySQL Workbench and it worked fine. I used the same SQL for my Table creation in Delphi and I keep getting errors. I split the SQL up into smaller chunks. The Recipes Table - np problem, Ingredients, No problem, but as soon as I start putting i...

Thanks for the "brain starter pack!", The wheels are slowly starting to turn again, but still in first gear. I managed to create the databases, create the tables, create Primary Keys and Indexes and the database seems to update OK (but I've only tested it with 2 or 3 entries). I presume th...

The second part of your reply works perfectly. Thanks a lot for that. When I saw it, it slowly stated to come back . . . Log term memory definitely suffers as years advance. Once needs to keep the old brain in gear at all times! I still didn't manage to create a Primary key, I'm working on it. Thank...