can any one help me please
try
IF Vendor.FINDSET THEN REPEAT
VendorLedgerEntry.SETRANGE(“Vendor No.”,Vendor.“No.”);
IF NOT VendorLedgerEntry.FINDFIRST THEN
BEGIN
vendor1.RESET;
vendor1.SETRANGE(vendor1.“No.”,Vendor.“No.”);
IF vendor1.FINDFIRST THEN
vendor1.DELETE;
END;
UNTIL Vendor.NEXT=0;
I suggest don’t delete the master just blocked them as in future there will be transaction for those vendor.
Just think again before deleting the master…
i created a table with the fields of
number,name,emailid
i have entered the values
number name emailid
1 x x@gmail.com
2 y y@gmail.com
i created a table with the fields of
number,name,emailid
i have entered the values
number name emailid
1 x x@gmail.com
2 y y@gmail.com
3 z zgmail.com
4 a agmail.com
where we can find above table containing values in the emailid field ,some of the fields which consist @ ,and some are not
at this point of view about my question is
list all email ids which don’t have @ symbol and delete them
i have gone through the strposition function where this function could helpful for knowing the string position of @ symbol
can you please help me