RE: another rookie question

2013-09-12 Thread Gary Jeurink
sion of Pandora without needing to close it everytime the phone rings to bring up another task I wrote. What about compiling to an .exe or .com? -Original Message- From: Kurt @ VR-FX [mailto:v...@optonline.net] Sent: Wednesday, September 11, 2013 1:44 PM To: profox@leafe.com Subject: Re:

Re: another rookie question

2013-09-11 Thread Kurt @ VR-FX
It sounds to me like one of your Apps is trying to lock a file and use a Table Exclusively. For your purposes - you should probably open the DBF files in SHARED Mode - and maybe THAT will solve your problem... And - by now - I no longer consider you a Rookie! :-) -K- On 9/11/2013 2:29 PM, Gar

Re: another rookie question

2013-09-11 Thread Kevin Cully
Quick answer; take a look at the SET EXCLUSIVE OFF command. This allows you to have multiple tables open, by multiple applications. You're not asking about how to build an executable (BUILD EXE {application} from {project name}), as opposed to an application being run from inside of VFP? -K

RE: another rookie question

2013-09-11 Thread Tracy Pearson
Gary Jeurink wrote on 2013-09-11: > Since I first learned how to make apps, I have made 1-giant one that runs my > whole house but when I want to do a specific thing, I have to close the > giant app to bring up the other because they share something. I want to make > several that can run at th

another rookie question

2013-09-11 Thread Gary Jeurink
Since I first learned how to make apps, I have made 1-giant one that runs my whole house but when I want to do a specific thing, I have to close the giant app to bring up the other because they share something. I want to make several that can run at the same time (even might share a table or two).

Re: another rookie question

2012-07-16 Thread Eurico Chagas Filho
;Sent: Monday, July 16, 2012 5:25 PM >Subject: Re: another rookie question > >How to do capture the ID it created for use in FKey columns for >adjoining tables?  Just stuffing data into a single table is easy. > > --- StripMime Report -- processed MIME parts --- multipart/alt

Re: another rookie question

2012-07-16 Thread Rafael Copquin
But I believe his question was a simple one: how to insert a new record into a view with a autoincremental field (which is readonly). I just gave him an example of how to do it Rafael El 16/07/2012 05:25 p.m., Stephen Russell escribió: > On Mon, Jul 16, 2012 at 3:16 PM, Rafael Copquin > wrote: >

Re: another rookie question

2012-07-16 Thread Fred Taylor
If you know your ID's are good, you can temporarily turn on/off the ID's in SQL: set identity_insert [databasename].dbo.tablename on on allows inserts with the ID field populated by your data, off is normal, SQL will populate the ID field on insert. Fred On Mon, Jul 16, 2012 at 1:25 PM, Stephe

Re: another rookie question

2012-07-16 Thread Rafael Copquin
You have to remember that autoincremental fields are readonly. What I do is something like this select myview scatter name oView blank fields except kw_id with oView .field1 = && you fill the object field properties with the values to be inserted in the corresponding field .field2

RE: another rookie question

2012-07-16 Thread Tracy Pearson
Stephen Russell wrote on 2012-07-16: > On Mon, Jul 16, 2012 at 9:17 AM, Eurico Chagas Filho > wrote: > Well, using a 'Globally Unique Identifier' I don't have the option of re-starting from 1 when ever I want. > I can't create my own primary key to correct something that needs a specific key.

Re: another rookie question

2012-07-16 Thread Eurico Chagas Filho
ing to the database, when it is just one  view of a parent table no need for this. Finally, I come from VFP 3.0, . E. > > From: Man-wai Chang >To: profox@leafe.com >Sent: Monday, July 16, 2012 10:15 AM >Subject: Re: another rookie question

Re: another rookie question

2012-07-16 Thread Man-wai Chang
Why not use UUID as primary key? On Mon, Jul 16, 2012 at 1:43 AM, Eurico Chagas Filho wrote: > I don't use auto generate keys. I have a DBF file called setup with two > fields, > key_name and value that sets the primary keys for all files. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bi

Re: another rookie question

2012-07-15 Thread Eurico Chagas Filho
I don't use auto generate keys. I have a DBF file called setup with two fields, key_name and value that sets the primary keys for all files. The class that creates all my views may or may not call a function, newid(), that sets the value. All DBF files that have a primary key, call "newid()" from d

another rookie question

2012-07-15 Thread Gary Jeurink
Since foxpro6.0 doesn't have an auto increment function. How do I insert a new record from a view that has a (primary key of kw_id). I am developing a database of program keywords. I just added the kw_id (int) field thinking it was necessary to make each record unique in order to update from views.