hello friends..
i need send mail working sample...
please upload...
26 2021-09-06 11:29:48
Topic: send mail (8 replies, posted in General)
27 2021-08-31 19:48:33
Re: How to handle prices and taxes changes? (6 replies, posted in General)
I have some suggestions for you....
If you are developing like pos software or invoicing software then you have to add 3 different tables
1 itemes 2 sale and 3 invoices
28 2021-08-31 07:20:39
Re: How to handle prices and taxes changes? (6 replies, posted in General)
You have to use prices in each transaction... for example you are selling some items then you have to add price column and taxes column in sale table.
29 2021-08-29 20:02:24
Re: Where is dmitriy (12 replies, posted in General)
Great speech...
we ask for dmitriy because we miss dmitriy...
31 2021-08-27 18:52:11
Re: buttons (8 replies, posted in General)
Yes... please send... i'll use there buttons...
32 2021-08-27 09:25:59
Topic: buttons (8 replies, posted in General)
how to make this type of buttons
33 2021-08-27 09:03:01
Topic: error (0 replies, posted in General)
hello friends.. i have a problem.
when i apply fromdatetime filter 2 or more months then this error shows..
34 2021-08-25 19:15:04
Re: Dataset to recordset (22 replies, posted in General)
Thanks....ehwagner
I am using query in rs.open('my sql query')
I applied a condition if combobox value is > 0 then my query so i wrote 4 queries with different clauses. Now its working...
35 2021-08-25 12:11:05
Re: Dataset to recordset (22 replies, posted in General)
how to write sql query if filter variable is null
36 2021-08-25 08:11:01
Re: Dataset to recordset (22 replies, posted in General)
thanks ehwagner working Properly
37 2021-08-24 18:41:31
Re: Dataset to recordset (22 replies, posted in General)
hello... after struggle of many hours i found datetime format to retrieve data from sql server database...
but now how to add Datetime picker is this formate...
because when i set ''mypicker'' then sql throw error.... please check it in Uploaded pic and see carefully...
38 2021-08-24 13:38:06
Re: Dataset to recordset (22 replies, posted in General)
thanks for reply...
.basically i have a software that is connected to fuel dispensers and stores data into mssql database.
i am developing an external software that print data and generate summary. that is reason to filter data directly from sql database...
39 2021-08-24 09:30:17
Re: Dataset to recordset (22 replies, posted in General)
But i need filter on access db because i want to load filterd data not all...
40 2021-08-24 07:33:05
Re: Dataset to recordset (22 replies, posted in General)
great example. thanks..
can you tell me how to load data using datetimepicker filter
41 2021-08-23 14:26:39
Re: Dataset to recordset (22 replies, posted in General)
I am facing some problems to retrieve data from sql server...
I mean filter by datetime...
42 2021-08-23 14:25:24
Re: Dataset to recordset (22 replies, posted in General)
Where is dmitry...
Is he supporting MVD now...
43 2021-08-23 08:08:13
Re: Dataset to recordset (22 replies, posted in General)
Can we load all data????
44 2021-08-22 13:15:40
Re: Dataset to recordset (22 replies, posted in General)
hello K245 and ehwagner
i found a solution but not exactly working like i want...
i want to print all data but its print 1 row... please check it
45 2021-08-22 08:46:25
Re: Dataset to recordset (22 replies, posted in General)
Thanks ... k245 told me that i did not found any solution in mvd to genrate report from sql server... i think this is the best way to print my selected data...
Thank you very much to guide me...
46 2021-08-20 15:33:21
Topic: Dataset to recordset (22 replies, posted in General)
Hello sibprogsystem....
I need your help...
I am retrieving data from mssql server database..
How to genrate report using fast report...
And how to convert recordset to dataset..
47 2021-08-20 15:15:27
Re: Microsoft SQL Database (MSSQL) with script (6 replies, posted in Script)
Hello livexox... are you available on this platform
48 2021-08-19 18:48:38
Re: [SOLVED] Auto fill db table only on first application run (2 replies, posted in Script)
Try this
If Vartostr(SQlExecute('select count(id) from tablename'))='0' then
Begin
SQLExecute('insert into tablename(columnname) values('myvalue')');
End;Try this in
Begin
End.
49 2021-08-18 14:53:02
Topic: Where is dmitriy (12 replies, posted in General)
Can anyone tell me that where is Dmitry...
50 2021-08-18 07:30:53
Re: dataset to record set (3 replies, posted in General)
Thanks but this is just print sqlreport tutorial..