griff
we use this on a duty detail order of a security personnel where
name of guards then the firearms
some client have more guards than firearms, so the excel file i sent is some example. i use join but the name repeats itself until all firearms for that unit is get by sql, then next guard...
good day sir/madam
attached is an excel file with sample table is the result can be possible in sql and how can i command that on sql. thanks and more power.
can i produce a graph with fixed x and y axis, i will used this on a puretone audiogram (audiometry)
here is the sample
125 250 500 1000 2000 4000 6000 8000
0
10
20
30
40
50
60
70
80
90
100
110
125 250 500 1000 2000 4000 6000 8000
data of this is from 0 - 110 only but i need to display...
good day guys
how can i overcome this invalid coordinate, i need to print the report in text file, but it keeps on saying the invalid coordinate
any comments
thanks in advance
i used hpd2560 and canon ip1880 same page layout only the contents are changed, it ejects the first page then it prints the last page which is on the second page, btw i used vfp9 sp2 version 09.00.0000.5815
SELECT * FROM firearms WHERE agency='M' INTO CURSOR x
rEPORT FORM firearms NOCONSOLE TO PRINTER NOPAGEEJECT
SELECT calivgauge,coun(calivgauge) FROM firearms WHERE agency='M' GROUP BY calivgauge INTO CURSOR xx
rEPORT FORM firearm1 NOCONSOLE TO PRINTER
i try the above command but the first...
guys,
lets say there are 5 records in the first table
let say its name
print the 5 names
then lets say there are 10 records in the second table
then print it immediately after the 5 names
name1
name2
name3
name4
name5
second table data 1
second table data 2
and so on
in same page
can this...
hi guys
is there a possibility to make a report came from two table?
all i want is to print all data on the first table then
print all data on the second one, is this possible? the two table structure is not identical.
any suggestions, thanks.
hello guys
can i edit query at runtime
inside fox i can edit it using
vfile=cquery
MODIFY QUERY &vfile
how about when the program is standalone executable
well i have done it i use fied properties / print when / print repeated values = no /also print / when this data group extension changes = checked then the group name and that all. God Bless and happy new year
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.