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

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...

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...

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 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

hello everybody, i'd like to scan a table. but instead of using the column-names to access the fields, i'd rather want to use indices, just like acessing an array. but i don't want to copy the table into a array. i appreciate any ideas... cheers alex

hey folks, i know, there is a function calles CURDIR(), but that isn't what i want. i need the path, where the compiled *.exe is actually placed at runtime. thanks! alex

hi folks, how can i obtain all records, wich are in table &quot;A&quot; and not in table &quot;B&quot;? (select * from A where A.key not in (select B.key from B)) gracias alex

hi folks, i know this is probably very simple, but i need to know, how i can pass arguments to a *.prg, when it is already compiled and should be run from the cmd. cheers alex

hi folks, is there a way to determine the information available in the task manager within a *.prg? muchas gracias alex

hi folks, i do have a little *.prg, wich does some queries on some tables and puts the result on my webserver. now, i need that *.prg as a system's service on windows2000, so that no user has to be logged in in order to run the update. funny thing is: i used the windows 2000 resource kit...

sorry for that one, but i need some inspiration... if you do a &quot;select distinct a,b,c from sometable&quot;, you get rid of the dublicates. so far, so good. but if you only want to get rid of the duplicates in a, but you also want to retrieve the corresponing b and c, what are you supposed...

hi, does anybody know, how i can register a new service, wich runs user independend (user: SYSTEM)? gracias alex

hello everyone, i do have a litle *.prg, wich i want to run as a service in windows. therefore i need some mechanismn, that controls that service, so that it runs only once a day. my idea: when it runs as *.exe, i need to check the system clock periodically. does anybody know how to do that...

hi folks, i've tried for several times to suppress the bottom scrollbar when using frames, but everytime the content of the frame exeeds the height of the frame, both scrollbars apear. thanks for any advice! cheers alex