Search results for query: *

hi folks, when using a distinct on a table, i only get the data one time. that's fine but in the following example it's a little inappropriate... having a table like this: id | email ---------------- 1 | a@b.com 2 | b@b.com 2 | c@b.com 3 | d@b.com 4 | e@b.com 4 |...

hi again, a question of interrest and frequent use: asume you got a table called costumer with columns id, name, email. you know there are some costumers in the db with the same name and email, but different id: ---id---|---name---|---email--- 1 john j@b.com 2 john...

hi folks, does anybody know, where vfp obtains the field lengths of a table when importing from excel? mfg alex

hi folks, i wrote a little *.prg wich executes a form. everything works properly except i compile it to an *.exe. after i press the "quit" button, the application disapears from the taskbar, but does remain in the taskmanager. any explanation? thanks! alex

i tried your solutions before, but i do have an array in the query string and therefore aidz98'code doesn't work properly. when using something like dkduge's code, a recursively growing querystring will result. so i'll try to ask a better way: what kind of mechanismns does php provide...

hi folks, i'm quite new to php, so don't wonder... i do have a form with already got some data in the query string. but when i try <form action&quot;<?php echo &quot;thisdocument.php?&quot;.$GLOBALS['QUERY_STRING'];?> name=&quot;myform&quot; method=&quot;get&quot;> ... i only receive the...

found in the form designer, but still the same result. i see the vfp enviroment popping up for a second and it's gone... cheers alex

no idea...where can i do that?

hi folks, i wrote a *.prg wich calls a form like &quot;do form myform with parm&quot;. within foxpro i can execute the *.prog and the form pops up and everthing is fine, but if i compile the *.prog and build an *.exe it doesn't work at all. (i see the form flimmering for a second). any ideas...

groovy! thanks! alex

i agree, but what if somebody installed excel in a different path? therefore i'd prefer a more generic method. thanks alex

hi folks, what kind of command should i use, if i plan to open an excel-file from a *.prg so that excel pops up? thanks! alex

hi folks, i beg your pardon for this stupid question but i would like to close a table explicitly, but &quot;mytable.close&quot; does not work and &quot;close tables&quot; as well. muchas gracias alex

hi mike, i was more intrested in where this value -4143 is comming from... btw, i do have good hand for things, which work generally, but not with me. therefore, i should become a tester. ;-) thanks anyway, i gonna check this on monday. have a nice and relaxed weekend! alex

morning folks ;-), mike: the &quot;xlWorkbookNormal&quot; was defined in your .prg, wasn't it? anyway, i tried it with hardcoding and got the same result. sorry for my ignorance, but what is this #define standing for? btw: i use various versions of excel, but non older than the officeXP...

sorry mike, but i've tried your &quot;Copy2Xls.prg&quot; in order to solve the 16384 problem. 1. thanks for offering a workaround 2. unfortunatelly, i can't use this due to an error at this line => loXls.ActiveSheet.saveAs(tcExcelFile, xlWorkbookNormal) errocode: 0x800a03ec and something...

hi folks, i run a script with a sql-query. when i browse the result, i can see 18000 records. after i use &quot;Exort to file.xls XLS&quot; there are only 16384 left. any explanation for this strange behaviour? thanks! alex

hi little helpers, is there a way to use regular expressions in vfp7? muchas gracias alex

sorry, this was corresponding to the suggestion with AFIELDS(). probably gonna start my weekend and check out things on monday ;-) cheers alex

well, the afields() would be approbriate, but i don't think it would be a good idea to put a lot of data into a array... (eats up memory, doesn't it?) ramanis version is, what i actually wanted, but is there a way to do it inline? i have tried: scan if &field(1) = &quot;&quot; then...