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...

One more to this in the field I will have AP-BONUS AP-PAYGRADE AP-PAYGRADE2 AND SO ON How can I get so all the AP's will will be grouped together. The way it is now when I run it I get the AP Wages Paid 2 77 789.00 AP Wages Paid 2 77 850.00 Should be AP Wages Paid 4 154...

That got it Thanks Mufasa Heydyrtt

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...

Yeah, that's what I was doing at first, which I guess I'll go back too. The problem I'm having is after I subtract the two times my result is 02:00AM, I just want a 2 or 02:00 will be fine, is there a way I could trim the AM or PM off. Thanks Heydyrtt

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...

Thanks 2ffat, That got it. Heydyrtt

What am I missing now, when I debug it, it shows the full path of the string in DM->tblClientspcanywhere_chf->AsString; When it gets to ShellExecute it just skips over it and does nothing. String PcanyPath; PcanyPath = DM->tblClientspcanywhere_chf->AsString...

Thanks r937, that got it. Heydyrtt

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

I get this to work, but it's really not what I need, ShellExecute(NULL, NULL,"c:\\docume~1\\alluse~1\\applic~1\\symantec\\pcanyw~1\\Bonner.chf",NULL,NULL, SW_SHOWNORMAL); This is a helpdesk program, on each client I need to have the chf file associated with them, so I'm posting to the clients...

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

Research the nvl function, it is used to convert null values to whatever value you declare. So, maybe you can turn the nulls to a 0 or 1 which is read as checked or unchecked. Just a thought 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...

Nevermind, found it SMTP1->PostMessage->ToAddress->Add(); Was the problem. Heydyrtt