Search options (Page 3 of 7)

Hello Derek,
thank you for the ideas and the project. Both from you guys are excellent. I will be seeing the customer at the end of the week and tell them there are options. Really appreciate the input from you both.
Regards,
David

Hello Math,
thank you for the demo code. It inserts the various fields so can I learn from the format of your command.
I don't understand why you have made the date field into a TEXT field. Where a field is to be a date, is there some sort of rule to apply to determine when the field type should be a DATE or TEXT? What about if SQL SELECT commands are used on the data file and the field containing a date is a TEXT field?
Is there some condition where a field containing a time should be a TEXT field?
Thanks again for your help, really appreciate it.
Regards,
David

Hello Mathias,
In reality, my project involves various types of data such as Data, Time, Text, and numbers. There is hardware that forms the entire string and I receive the data through the serial port. The string is comma delimited and I get the various fields out of the string. The date and time is not part of the string received in the PC.
I wish to write the received data into a table using SQLExecute. The data and time part of it are just the local date and time on the computer and I would like to write this local date and time into the database for each record. The data is received in close to real real time so that is fine.
I attached an example so I could practice writing various data types into the file but it all went wrong and aren't sure where so I removed most of my SQLExecute and would appreciate it if you could complete that line for me.
In the test project attached, there are boxes to write a text and enter a integer and real number and these should all be written into the data file just one record at a time as the Add button is pressed.
I hope that makes sense.
Also, the SQLExecute lines become quite long so could you tell me the best way to spread a SQL command over multiple lines please.
No pressure at all, I am only progressing as I can and as others are able to help.
Thanks and regards,
David

Hello Derek,
thank you for the ideas, really appreciate it. I have tried it and it is knowledge that I can make use of.
Regards,
David

Hello ehwagner,
thank you so much for all your help with this. Both methods work well. With the second one, I also added your same code to both OnKeyDown and OnKeyUp for the TableGrid so it now works for both using a mouse and for stepping through the records using the up and down cursor keys.
Thanks and regards,
David

Thanks Dmitry,
When running the code you supplied, there is no data at all added to the memo field. I added a couple of lines as below.

procedure OnRecieveComData(Sender: TObject; Data: string);
var
    sLine: string;

begin
sLine := sLine + Data;
    if Pos(Data, #13) > 1 then
    begin
      sLine := ReplaceStr(sLine, #13, '');
      sLine := ReplaceStr(sLine, #10, '');
      TelemetryArray := SplitString(sLine, ',');
      Form1.Label6.Caption := TelemetryArray[0];
      Form1.Label7.Caption := TelemetryArray[1];
      Form1.Label8.Caption := TelemetryArray[2];
      Form1.Memo1.Lines.Add(sLine);
      sLine := '';
    end;
    Form1.Memo1.Lines.Add(sLine);        // Added by David
    sLine := '';                                                  // Added by David
end;

With the modified code as above, I get the data printed out again but in the incorrect way still.
I have checked the code for the micro controller and there is no control codes are anything else added. It is just simply ASCII characters.
Then I changed the code in the micro controller so it would send a shorter string. The problem remained in that the text added to the MEMO box is still spread over two lines.
I have now tried four other software programs which all display the received data correctly with the complete string as a single line.
Please find a text file attached which has data recorded with a comms program..
thanks and regards,
David

Hello Dmitry,
Thanks. Please find the project attached and a screenshot is included in the zip file.
The string read into the COM port is about 50 characters and it arrives with the commas in place, just as you see it on the screen except when it is received in the MVD application, it splits the data across two lines. Then when I use the SplitString function, it only acts on the second line that appears in the window. Really I need to be able to split the string into its 8 parts.
I have tried several other serial communications programs and they always display the data as a single line each time a transmission is received.
I am using the latest version of MVD.
Once we get past this situation, I need to add another 20 to 30 bytes to each telemetry string.
Thanks for your help.
Regards,
David

Hello tcoton,
thank you. I just found http://myvisualdatabase.com/forum/viewtopic.php?id=362 which must be the one you mean. It works. Only thing is that a field I change in the record is one that appears on the Tablegrid and once I save the record. The updated field entry does not appear on the Tablegrid. I need to press the SQL Query button again to make the grid show the updated data. I tried using dbUpdate on both on closing the form and after click on the save button but neither worked.
Thanks again for your help.
Regards, David

Hello Derek,
nice to hear from you. All is well here and I hope same for you. Its the middle of the night for you so you must really enjoy programming. I am working on a school project with my son so it is attached here but it is 16Mb zipped (remove image so file is small enough now). I did remove the image and resend if you it can't be sent as it is. Once you run it, please click the "Quick Select" button and then the "Medical Issues" button. I would like to be able to have the edit form appear and edit the "Medical issues" field. You will see that the other fields on the edit form are read only. Created in version 4. Hope it all makes sense. Thanks again and nice hearing from you.
Regards,
David