sele YourTable scatter memv blank if !empty(thisform.text1.value) m.field1 = thisform.text1.value endif ..... if !empty(thisform.textn.value) m.field1 = thisform.texte.value endif insert into YourTable from memvar>thank you for reply
>>>decision no 1 chld desc memeo(blabla.....) >>> 1 1.1 desc text chr(254) >>> 1 1.2 >>> 1 1.3 >>> 1 1.4 >>> . >>> . >>> 1 1.10 >>>***************************************** >>>decision no 2 chld desc memeo(blabla.....) >>> 2 1.1 desc text chr(254) >>> 2 1.2 >>> 2 1.3 >>> 2 1.4 >>> . >>> . >>> 2 1.10 >>>************************* >>>. >>>. >>>decision no 30 chld desc memeo(blabla.....) >>> 30 1.1 desc text chr(254) >>> 30 1.2 >>> 30 1.3 >>> 30 1.4 >>> . >>> . >>> 30 1.10 >>>************************************** >>>at the table >>> >>>appen blank >>>&&if not empty >>>replace fields with .......&if not empty >>> >>>>>>thanks