Search results for query: *

I have an array of text boxes how many text boxes is determined by what is in a db column. I have a listview, that displays what was entered in the textboxes, via a sql query. On my form a have modify button, when clicked the lisview is enabled and the user can select a row in the view to...

Need to know how to get columnheaders from a db field, other than what my recordset is. I have a one table where the location_mask column is located, the data in this column is for locations and it like BLDG POD CELL FLR this is all in one column. And the grid data I'm retreiving is in a...

Hello, Hoping this can be done, Have two tables facilities and payment_detail Facilites table has a column facility_code, which is 3 characters like MDN. Payment_Detail has a column account_number which contains the facility code and account number, it would look like MDN123456Booker/Tim...

Hello, I have a field called payroll_name and the data in it is like AP-Bonus, CH-PayGrade, Dumpster Program. The query needs to look for the dash (-) if it's not there like for Dumpster Program then column needs to read "All other wages paid". If it's AP- CH- or what ever the AP- will be...

I have a table that we will be exporting into a comma delimited file. The problem I've ran into is on column lastname, some of the lastname are like Smith, Jr. This comma is causing problems once exported to csv. Any one know away to get that out, other than record by record. Thanks Heydyrtt

Is there a way to make the below strings read only. I will still need to enter notes in the memo field, just want to prevent the Lines added from being deleted. How can I have that read only and still use the memo field. String ModifiedDate; ModifiedDate = "Modify Date:"+Now(); String...

The query below works if the date is this month, example when I run the query and dates are 11/01/2004 it will show 4 for four days. But the dates that show up in query for last and prior months is shows a negative number like -6 for 10/11/2004. How can I correct this. I'm trying to get the...

Hello; Trying to calculate the time from two time fields, both fields are time fields in the table (mysql database). This works when I just query the table from mysql, but can't get it to work in cpp. The Time column is for the total time spent which will be like 2:00 for two hours. SELECT...

Have a table with a starttime and endtime, need a query that will tell me how much time was spent using starttime and the endtime. If the start time is 11:00 am and endtime is 1:00 pm I need the query to display that it took 2 hours. Thanks Heydyrtt

Has anyone had any luck opening a pcanywhere chf file within cpp. I've tried Shellexecute(Handle,"open","c:\pathtofile\file.chf",NULL,NULL,SW_SHOWNORMAL). With no luck, any suggestions. Thanks Heydyrtt

Need to know how to export quickreport to word doc using the rtffilter. I have the rtffilter on the report, what I do now is preview the report then save as .doc which works fine, but would like to be able to do it in code without having to preview report. Can this be done. I have found several...

This is a helpdesk program, when a person enters a trouble call and assigns a tech to the call, to be able to send an email in the blind to the tech assigned. Any help appreciated. I'm using BCB6 Thanks Heydyrtt

Hey guy's Anyone know an easy was to do this with two databases. This is a helpdesk program running oracle(not web based program), the tech's will enter their daily calls during the week, on their laptops. On Friday's they will need to upload data to master database which is identical to...

Main form is loaded, and I load a another form, when the focused form is up and if I minimize the main form, the focused form stays on the screen, does not minimize with main form. How do you make the focused form stay with main form. Heydyrtt

Using a basic data form to print reports, how do you get the print dialog screen to appear in order to select a printer from the drop down list? Thanks Heydyrtt

Need to know how to use the TOpenDialog to browse to a folder and once the folder is selected to get the path of that to display in DBEdit field. Thanks Heydyrtt

I have lookupcombo which displays lastname and firstname, in this format smith,john. I need the query below to the return the results of the history of the name thats in the combobox. What I have doesn't work, works fine if I just go by lastname. can't get it to work off last and first tho. The...

Hello, Having problems with tblMaildate->AsDateTime = Now(); What I'm doing is, Onclick event I open table, and append after the append I have the AsDateTime = Now() which puts the todays date in the date field. Well it works the first time, after I post and click for a new record again it...

Whats the difference between query unload, and unload event? Heydyrtt

I need to do a calculation of two fields, field1 / field2 then need to get the percentage of the result from the divide by 100%. Below is what I have written so far, which it works, but doesn't give the right percentage. SELECT a.items, a.orders, c.items_credited, SUM(c.items_credited) /...