Link to home
Start Free TrialLog in
Avatar of 966
966

asked on

MY DAC sql

hI,

MyDac component.

I installed the trial. What happens when the 60 days are over. Will executable programs ive made with it stop working?

Also,

Can someone give me an example of how to connect to an exising SQL database using MyDac

Ill need it so onformcreate, it connects and enters a new field in the SQL.

if you can write an example, so i can edit the details of my SQL server , pass and database.
Avatar of Mahdi78
Mahdi78
Flag of Algeria image

try this

with MyConnection1 do
 begin
 Server := 'yourserver';
 Port := 0; // your MSSQl port
 Username := 'username';
 Password := 'passwoed';
 Database := 'yourdatabase';
 connect;
end;
Avatar of 966
966

ASKER

what component should i put on the form, As there is lots by mydac
Avatar of 966

ASKER

hang on, ignore that. ^^  give me a few mins
Avatar of 966

ASKER

thanks it works great, but how wouldi add something into the table, say for example.. under users add another field ?
Avatar of 966

ASKER

and also is there a way to list the database ? or if its too long code, tollist the database name
to open table use the following

MyTable1.Connection := Myconnection1;
MyTable1.TableName := 'yourtable';
MyTable1.Open;

to get database list into ListBox1 use the following

procedure TForm1.Button1Click(Sender: TObject);
begin
Myconnection1.GetDatabaseNames(ListBox1.Items);
end;
Avatar of 966

ASKER

sorry i dont mean to ask questions, but

1) how would i actually add a name inside the users field of the SQL, its the onyl field there

2) where can i get information examples and tutorial on these compoents

3) what happens when trial expires, does it effect any of my applications i have created ?
Avatar of 966

ASKER

also

Myconnection1.GetDatabaseNames(ListBox1.Items);

how can that list DATABASE_HELLO instead of them all
ASKER CERTIFIED SOLUTION
Avatar of Mahdi78
Mahdi78
Flag of Algeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
As far as your initial question, I believe they will not work but if they do, you will be in violation of the EULA.

The trial version is just that for a trial.  It is meant to allow you to see if Crystal is for you.  
In the  past, Crystal has been very careful in guarding and protecting its products.  I have seen nothing to change that with their acquisition by SAP.  If anything they have gotten more aggressive.

mlmcc