Search options (Page 5 of 25)

javeriya1695,
As tcoton mentioned, is there any data in the database table being imported. In other words, is there any data present in the physical table after the import. I'm not talking about the tablegrid, but the actual table. You may need to parcel out some of the script to see where the breakdown is.

It is very difficult to debug a project without the project. It would be beneficial if you could attach your project.

Hedan,
I haven't had the problem.

rbknathan,
Just curious. What is wrong with Derek's solution? Why do you need row number?

I am attaching another way, but I really do not understand the necessity of having a number in the combobox. I added onto Derek's example (Thank you Derek).

You can also you use SQLQUERY on a button action.

Frank,
You need to include the cboState field in the SAVE RECORD action of your SAVE button. It's an easy oversight even for veteran developers.

dan.hdez.rdez,

Not sure what you mean here. But since we don't have access to your MySql database we'll have to try to test with Sqlite. Do you have a copy of your Excel spreadsheet that you can upload for us to use.

You can connect through script by doing the following:

procedure Form1_OnShow (Sender: string; Action: string);
begin
     frmWait.Show;
     Application.ProcessMessages;

     {$MySQL disable_connectdialog}
     Form1.MySQLConnection.Server := '127.0.0.1';
     Form1.MySQLConnection.Port := 3306;
     Form1.MySQLConnection.Username := 'root';
     Form1.MySQLConnection.Password := 'root';
     Form1.MySQLConnection.Database := 'mvd';

     try
         Form1.MySQLConnection.Connect;
     except                                                                    
         frmWait.Close;
         ShowMessage('Can''t connect to database.');
         Form1.Close;
     end;

     if Form1.MySQLConnection.Connected then
     begin
         UpdateDatabase(''); // to fill ComboBoxes
         Form1.GridEmployees.dbUpdate; // if you have TableGrid on first form with option "Enable auto execution", you should call method dbUpdate manually
     end;
     frmWait.Close;
end;

To remove the standard menus in MVD you can use the following script:

Form1.mniFile.visible := false;
Form1.mniClose.visible := false;
Form1.mniOptions.visible := false;
Form1.mniSettings.visible := false;
Form1.mniReport.visible := false;
Form1.mniExportData.visible := false;
Form1.mniImportData.visible := false;
Form1.mniAbout.visible := false;

agusecc,
According to Dimitry the new versions of Windows does not allow you to change the color of buttons and checkboxes. For checkboxes what I do is clear the caption in the checkbox properties and then insert a label next to the checkbox. Then you can make it any color you want. Doing it this way, you can place the label on either side of the checkbox.

unforgettable,
Dates in databases are stored in the YYYY-MM-DD format so you need to reformat your datetimepickers in that format.

form1.Edit1.Text:= SQLExecute('Select Sum(svalue) from Sale Where Date(Date1) >= "' + FormatDateTime('YYYY-MM-DD',Sale.datetimepicker1.DateTime) + '" and Date(Date1) <= "' + FormatDateTime('YYY-MM-DD'',Sale.datetimepicker2.DateTime) + '"');

Adam,
Sounds did not work because you didn't have any code to play any sounds. I created a sound folder and put a sound in there. Code was inserted to play a sound when the task reminder time arrives.

Adam,
Revised project attached. I changed you timer procedure a little. One thing was your date comparison needed to compare date format as 'YY-MM-DD'. You have the option to pick an alternate message so I put in a check for the alt text to be displayed if the checkbox is checked. Also, you need to be able to check for an alert notification for a task if the date/time has passed while the program is not running. So if a date and time has passed when you start the program you will get a notification immediately. And finally, you need a way to shut off the reminder otherwise you will get notified every second. So I put in an update to set the reminder datetime to null after notification.

I also put in a doubleclick procedure for the tasklist tablegrid in order to be able to edit from the tablegrid. This may be needed if you have overlapping tasks.

unforgettable,

Yes you can add any number of fields.

Yes you can add Service field. I'm not sure what it means or how it is to be used, but you can define it on a table.

You can add discount to the Sales Ticket and have a calculation to subtract it in the Sales Ticket form.

The short answer is YES. However, you are getting into more sophistication in your project. It seems like what you were putting together was a simple Point-of-Sale project with the ability to report on profit and losses on sales. But now when you mention "receivables and balance", you will need to incorporate more data tables and processes. If you want to maintain receivables and balances of what is owed, you will now need to define a Customer table and probably an invoice table, at minimum, and of course new forms and reports to take care of the processes. This all can be done in MVD, however my time is limited on the forum. If you can elaborate more on the design of your total application, I will try to put something together for you to at least get you headed in the right direction, but I can't guarantee my time. Piecemealing little bits at a time is not good for an efficient application development. Things like I mentioned in my last post with the dates in two different tables is not good database design. This kind of thing can happen when a design is not totally in place or known. Maybe you do have it all designed and I just do not know it. It just makes it more difficult on this end to come up with good solutions.