Search results for query: *

I have a table with memo fields, dates etc and want to convert to an sql database. I read somewhere memos had to be changed but don't remember how and same for dates. Is there any sample code around that would show how?

Thanks - will save me a lot of headaches. always thought it meant 5 digits, 3 before decimal and 2 after....

I created a table with a rate in it of N(5,2). In the master file, the rate was N(7,2). When I inserted the master rate into the created table, a rate of 191.25 was stored as 191.30 basically code is select master store rate to m.createdrate insert into created from memvar I you wait window...

That code didn't work - always returned 1 copy as well. I will try a simple form where the user can select printer, copies etc.

Hi Mike - I didn't write a simple form to do that but while searching on another site was given the following sample. Just about to try it. ** Converted from: ** http://msdn.microsoft.com/en-us/library/ms646829.aspx

Is there bug in VFP - I tried following to get _pageno incremented but even with no reset and select 3 copies, _pageno came out as 1. WAIT WINDOW _pageno REPORT FORM FESI501 NOCONSOLE NORESET TO PRINTER PROMPT WAIT WINDOW _pageno

Hi Mike - I tried the function but no luck. Even moved it into the header, specified 3 copies but only got count of 1. The function is very simple - see below _screen.AddProperty("countinfo",0) DO FORM fesi501 && This form lets me enter custno then wait window shows the count after report is...

Thanks CDavis, that works beautifully. I love this site.

code below creates the txt file but with blank line at top of page. Is there some way to prevent that? SET TEXTMERGE on STORE FCREATE("c:\TEMP\testit.txt") TO _TEXT && Create low-level file LOCAL lcxxx STORE SPACE(900) TO lcxxx...

That didn't work - I selected 3 copies in print dialog and countit only set to 1 - I put the function in the summary band... Iwill try other ideas and let you know

Thanks Mike - could I put a counter in a screen variable - say I set _screen.countit to 0 just before running report then in the function add 1 to _screen.countit etc etc

Thanks - I stuck a wait window _pcopies after the print but it was set to 1.... So your idea might be only way.

Is there anyway to find out how many copies of a report were printed. I have program where 3 reports are printed in a row. If operator selects 3 copies on first report print dialog, I want the following 2 reports (different frxs) to print 3 copies. I only have printer selection dialog on...