Derek that worked perfectly, many many thanks.
John
2 2022-05-18 11:07:17
Re: Newbie in My Visual Databse (16 replies, posted in FAQ)
Hi Derek and Jb,
Many thanks to you both and it worked fine, and please excuse my stupidity.
But what i really need is the id value of the last record in the table, as i should have known
the total record number is only going to work if you never delete a record.
In advance, many thanks for your help.
John
3 2022-05-17 14:27:31
Re: Newbie in My Visual Databse (16 replies, posted in FAQ)
Hi all,
Can anyone tell me the easiest way to to get the number of records in a table.
What i really want is the next sqlvalue so i would just add 1 to it.
Cheers
John
4 2021-10-15 17:01:28
Re: Report SQL (2 replies, posted in General)
Yes that worked perfectly.
Many many thanks.
John
5 2021-10-15 15:41:39
Topic: Report SQL (2 replies, posted in General)
Hi All,
Can anyone tell me what I'm doing wrong here.
select jobs.id, jobs.cust_n, jobs.del_n, jobs.your_ref, jobs.our_ref,
joblines.id, joblines.description, allocate.jobline,
allocate.location,allocate.id
from jobs, joblines, allocate
where jobs.id = '+jobsfiles.edit5.text+'
and joblines.id_jobs = jobs.id
and allocate.jobline = joblines.id;
The error is in the '+jobsfiles.edit5.text+' statement, so not getting the value of edit5
Kind regards
John
6 2021-09-30 15:22:06
Re: Printing a memo field (4 replies, posted in General)
Ok, Sorted it.
The sample you sent me worked fine, many thanks.
The sample i knocked up worked fine.
What i was doing. was printing memo1 instead of its database name footer.
Again many thanks for your reply and apologies for my stupidity.
Kind regards
John
7 2021-09-30 14:01:52
Re: Printing a memo field (4 replies, posted in General)
Thanks Guys for the reply,
No idea, will have a look at that sample, must be doing something stupid.
John
8 2021-09-30 12:10:56
Topic: Printing a memo field (4 replies, posted in General)
Hi all,
Producing a report that has memo fields in it, the report does not recolonise the line feeds entered in the memo field.
so
111
222
333
444
555
Is displayed in the report as
111 222 333 444 555
Has anyone got an answer to this.
Many Thanks
John
9 2021-06-21 10:18:46
Topic: Small network (1 replies, posted in General)
Hi Everyone,
Got a problem here and can't find an answer:
Created a database using using the sqlite data format.
This is to work on a small office network.
It works fine on my development machine, and works fine running from a network computer until a second user opens it, then it slows down 20-30 times when clicking down a table grid and displaying a form.
10 2021-05-07 13:26:51
Re: Access Violation (3 replies, posted in General)
Hi Derek,
Thanks for the reply, what is it you need, I can't unfortunately send the data with it as it .5gb and belongs to someone else (You know how it is).
I was hoping there would be some clue in the Violation numbers.
To be honest it's not the end of the world, i just have to remember not to use a form with 10 text box's.
Kind regards
John
11 2021-05-05 15:19:53
Topic: Access Violation (3 replies, posted in General)
Keep getting this when i close the properties on a button.
Access violation at address 0040698c in module myvisualdbase, read address 033b1000
This is odd, i create a new form, add 10 textbox's to it and get the error, if i add one or delete one it goes away.
Any help
John
12 2021-04-14 12:09:27
Re: Sql Update (2 replies, posted in General)
Thanks again Derek,
Yes it worked fine, and very clever in my mind.
I actually did this.
mach_tool.edit2.text := replacestr(mach_tool.edit2.text,'"','""');
SQLExecute ('update tools set machine = "'+mach_tool.edit2.text+'" where id_jobs = '+mach_tool.edit11.text+' ');
mach_tool.edit2.text := replacestr(mach_tool.edit2.text,'""','"');
Kind regard and much appreciated.
John
13 2021-04-13 12:12:26
Topic: Sql Update (2 replies, posted in General)
Hi All
Quick question, the line below works fine
SQLExecute ('update tools set machine = '+mach_tool.edit2.text+' where id_jobs = '+mach_tool.edit11.text+' ');
Except when the text string (mach_tool.edit2.text) contains an ("), then the sql command reads this as the end of the string.
I know i'm using the wrong syntax here, but don't know the correct one.
Any help would be great.
John
14 2021-04-02 16:59:43
Re: Odd Fault (7 replies, posted in General)
Hi Derek,
That worked a treat, Many many thanks.
If you lived near me in the UK the beers would be on me when the pubs open.
Have a great weekend.
John
15 2021-04-02 13:11:16
Re: Odd Fault (7 replies, posted in General)
Hi Derek,
Yes i am, trying to select items in the tools database who's id match an entry displayed in a form.
This is the only thing i'm having trouble with.
where id_jobs = '+mach_tool.edit11.text+' ;
This runs ok but not getting the value of '+mach_tool.edit11.text+'
If i replace it with a number it works fine.
John
16 2021-04-01 16:24:47
Re: Odd Fault (7 replies, posted in General)
Hi Derek,
Sorry mate it was me being a prat, I found the problem.
I expect it's me again on this if you could take a look.
select * from tools
where id_jobs = '+mach_tool.edit11.text+' ;
Trying to display a list from the tools database.
"id_jobs" is a from the tools data and "mach_tool.edit11.text" is from a displayed form.
If i replace mach_tool.edit11.text with a number it works and displays all the tools were id_jobs=2
Many thanks in advance
John
17 2021-03-31 17:08:16
Topic: Odd Fault (7 replies, posted in General)
Don't know if it me or a bug, I can't create child records for a database. It works ok from one database but if a delete the relationship and create a new one with another it doesn't work, i have deleted the data and tried, but no luck.
Has anyone else had this problem?
18 2021-03-18 13:59:00
Topic: Turning Off form icons (0 replies, posted in General)
Does anyone know how to turn form icons off, it has an option in the form properties but they don't seem to work.
John
19 2021-03-18 11:06:17
Topic: How do you refresh a form. (1 replies, posted in General)
Hi All,
When you have selected a record from a tablegrid and displayed it in a form, Then changed the data in the database in a script, how do you refresh the form.
I know the record ID so if there was a way to run the show command with the record id, that would be great.
John
20 2021-03-17 17:23:10
Re: How do you display the record ID in a form (2 replies, posted in General)
Many thanks Derek,
John
21 2021-03-17 14:07:41
Topic: How do you display the record ID in a form (2 replies, posted in General)
Hi Everyone,
Hope you are all well, Can anyone tell me how to display the record id in a form please.
John
22 2021-02-10 16:16:39
Topic: What is the script to show a record. (1 replies, posted in General)
Hi everyone, can anyone tell me the script to show a record in a for, i know i can do it with a button
(show record) but just need to do it from a script.
This i want to do from a single click on a grid, as below.
procedure Address_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer);
begin
?????????
end;
Many thanks
John
23 2021-02-01 17:23:37
Re: Running a command line from script. (2 replies, posted in Script)
Will take a look, Many thanks.
24 2020-12-16 15:59:08
Topic: Running a command line from script. (2 replies, posted in Script)
Hi Everyone,
Is there a way to run a command line in a script, you can run a file with IE "openfile('CmdTwain');" in this case to run a scanner, but i can't add any parameter's, like choosing file type or resolution that i can do from the command line or batch file.
Any help on this would be great.
John
25 2020-12-08 16:20:16
Re: What to implement first? (187 replies, posted in General)
Many thanks CDB, sorry for the late reply.
John