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.
966Asked:
Who is Participating?
 
Mahdi78Connect With a Mentor Commented:
1 - If you know SQL add field with TMyQuery, else use TMyTable
2 - About tutorial, check Demo folder of component
3 - I don't know what happen
4 - to use DATABASE_HELLO database use my fist post

with MyConnection1 do
 begin
 Server := 'yourserver';
 Port := 0;
 Username := 'username';
 Password := 'passwoed';
 Database := 'DATABASE_HELLO';
 connect;
end;
0
 
Mahdi78Commented:
try this

with MyConnection1 do
 begin
 Server := 'yourserver';
 Port := 0; // your MSSQl port
 Username := 'username';
 Password := 'passwoed';
 Database := 'yourdatabase';
 connect;
end;
0
 
966Author Commented:
what component should i put on the form, As there is lots by mydac
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
966Author Commented:
hang on, ignore that. ^^  give me a few mins
0
 
966Author Commented:
thanks it works great, but how wouldi add something into the table, say for example.. under users add another field ?
0
 
966Author Commented:
and also is there a way to list the database ? or if its too long code, tollist the database name
0
 
Mahdi78Commented:
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;
0
 
966Author Commented:
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 ?
0
 
966Author Commented:
also

Myconnection1.GetDatabaseNames(ListBox1.Items);

how can that list DATABASE_HELLO instead of them all
0
 
mlmccCommented:
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
0
All Courses

From novice to tech pro — start learning today.