I mean i can only add one record at one time in that given code..
i tried to use the for loop but got an error..
sory if the code is not maybe accurate cause i'm new in using loop.
LOCAL x as Integer 1
x = thisform.pgfinventory.addinventory.txtQty.Value
FOR n = 1 TO x
? n
SELECT item_table...
i have two tables with the same data but:
i this is i want
2nd table
itemquantity
product3
1st table
itemquantity
product1
product1
product1
i want that the quantity of a product in the 1st table is sum up to the 2nd table..
should i use locate and add the qty of the same product?..
i am new in creating new properties or methods,
i m done creating method but i cant find the method i created in my property window to code it.
please help..
SELECT item_table
LOCATE FOR status = "For Disposal"
IF FOUND()
thisform.pgfinventory.page1.grdItem_table.BackColor=rgb(159,255,230)
ELSE
endif
i want to change the backcolor of a record with a value of "For Disposal" in the status field
but it just change the back color of all the record
is...
actually i want to print different report,
if price is greater than 10000
then prints are.frx report of the selected name with the same number
elseif price is less than 6000
then prints ics.frx report of the selected name with the same number
else
messagebox(no report)
endif
tnx sir olaf..
i have table name issue
fields
id name item aqdate number price
sample records
1 bryan laptop 10/10/14 ARE#14123BY 10000
2 simon desktop 10/10/14 ICS#14321SY 10000
1 bryan van 10/10/14 ICS#14123BY 5000
want:
when i filter name bryan or number ARE#14123BY
filter number or the name and determine...
here is my code in selecting the picture
x = getpict()
if ! empty (x)
select item_table
SET ORDER TO itm_id
replace image WITH x
this.picture=item_table.image
[highlight #EF2929]thisform.refresh[/highlight]
ENDIF
thanks for your replies. found i that it was my refresh on the form...
....code in my interactive chage combo box...
SELECT issue_table
SET ORDER TO date
thisform.pgfinventory.issuetab.TXT_search.InputMask = "##/##/##"
thisform.pgfinventory.issuetab.txt_search.SetFocus()
....code in interactive change of my search textbox....
IF...
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.