Thanks. I followed the procedure above bu unfortunately no change.
Laurie
On 3 October 2014 13:23, Fernando D. Bozzo fdbo...@gmail.com wrote:
Hi Laurie:
Nexts steps are just for testing if doing what I've done, can resolve your
problem.
The idea is to regenerate the DBC as I've done, and
Interesting. I issued this in the command window:
DBSETPROP(residents_v,VIEW,Tables,members!members,members!hons)
MODIFY VIEW
shows DBSETPROP(residents_v,VIEW,Tables,members!members) but
DBGETPROP() returns the correct results.
Laurie
On 4 October 2014 08:17, Laurie Alvey trukke...@gmail.com
It seems that when there is only one table referenced in the fields list,
only that table appears in the tables list. Adding a field from a JOINED
table produces a table list including the new added alias. I don't want to
have more fields than necessary in the output - this is a pain. I'll build
a
The 3 DBGETPROPS() I've posted earlier have more than one table. Didn't you
copy/pasted them to compare results?
On 4 October 2014 09:54, Laurie Alvey trukke...@gmail.com wrote:
It seems that when there is only one table referenced in the fields list,
only that table appears in the tables
Yes I did but I only get one table if the field list only contains one
table. I think it;s because my version of VFP (7423) is different to yours.
Laurie
On 4 October 2014 09:36, Fernando D. Bozzo fdbo...@gmail.com wrote:
The 3 DBGETPROPS() I've posted earlier have more than one table. Didn't
I wonder if there is some confusion here: as far as I can see dbgetprop
returns a list of the tables actually used in a view (if the view does
not include any fields from a table then it is not /used/ in the view).
For whatever reason there is no */tables/* attribute for the database
itself
.. looking at this a bit more it seems that a table field must be used
unqualified in the view - /fielda/ is OK but e.g. sum(/fielda/) is not/.
/Example - in the NorthWind database:
jj=DBGETPROP('summary_of_sales_by_year',VIEW,Tables) returns an
empty string/
I've doing some testing on this, and found this:
- Apparently the table name list shown are taken starting from last
expression
- If a field of a table excluded from the table list is taked out from the
view, this does not update the table name list
- To show all tables, apparently is needed that
This is all clear now. Thanks to all.
Laurie
On 4 October 2014 11:19, Fernando D. Bozzo fdbo...@gmail.com wrote:
I've doing some testing on this, and found this:
- Apparently the table name list shown are taken starting from last
expression
- If a field of a table excluded from the table
Congratulations and thanks to Fernando for his very professional follow-up on
this thread. I learnt a lot.
Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud
Le 4 oct. 2014 à 12:29, Laurie Alvey trukke...@gmail.com a écrit :
This is all clear now. Thanks to
I think that might be the problem. My version of VFP 9 (SP2) is
09.00..7423.
Laurie
On 2 October 2014 23:53, Fernando D. Bozzo fdbo...@gmail.com wrote:
Hi Laurie:
Finally! I have tested it with your empty tables and DBC, and it's working
ok for me.
Some examples:
*Test 1:*
?
There are 3 hot fixes as well as the SP2. I think hotfix 3 is a combination
as they all replace the exe etc.
Al
-Original Message-
I think that might be the problem. My version of VFP 9 (SP2) is
09.00..7423.
---
This email is free from viruses and malware because avast! Antivirus
Yes, one of the hot fixes (3, I think) changed the version to 7423.
Laurie
On 3 October 2014 10:04, Allen pro...@gatwicksoftware.com wrote:
There are 3 hot fixes as well as the SP2. I think hotfix 3 is a combination
as they all replace the exe etc.
Al
-Original Message-
I think
The problem seems to be in the view designer. This line should be (for
example):
DBSetProp(ThisView,View,Tables,members!members,members!hons) but in
fact is:
DBSetProp(ThisView,View,Tables,members!members)
Manually changing it and saving the view makes no difference - it always
goes back to the
Hi Laurie:
Nexts steps are just for testing if doing what I've done, can resolve your
problem.
The idea is to regenerate the DBC as I've done, and see if this fixes it.
1) Zip your DBC/DCX/DCT so you have a copy
2) Delete your DBC/DCT/DCT (the files that compose de DBC databases)
3) On your
Are you sure it's not there? I've just looked at the archive and the dc2
file is there (it's called members.DC2).
Laurie
On 1 October 2014 18:40, Fernando D. Bozzo fdbo...@gmail.com wrote:
Hi Laurie:
I am looking at your zip, but didn't find the structure of the DBC you are
talking on your
I've put a new file on GD (members.zip). Here is the link:
https://drive.google.com/file/d/0Bx9KhEueeFRhcnZiN2V2OU1PQ2M/edit?usp=sharing
Laurie
On 2 October 2014 10:25, Laurie Alvey trukke...@gmail.com wrote:
Are you sure it's not there? I've just looked at the archive and the dc2
file is
Laurie, you are right, I can see it now. Didn't saw earlier because too
many files :-P
Back to you later
El 02/10/2014 11:26, Laurie Alvey trukke...@gmail.com escribió:
Are you sure it's not there? I've just looked at the archive and the dc2
file is there (it's called members.DC2).
Laurie
Hi Laurie:
Finally! I have tested it with your empty tables and DBC, and it's working
ok for me.
Some examples:
*Test 1:*
? DBGETPROP( 'DECEASED1_V',VIEW,Tables)
*I get:*
members!members,members!hons
*Test 2:*
? DBGETPROP( 'FULLLIST_V',VIEW,Tables)
*I get:*
I figured I was looking in the wrong place. Here is the link.
https://drive.google.com/file/d/0Bx9KhEueeFRhNkZGTVk5YnZDRjg/edit?usp=sharing
Laurie
On 30 September 2014 18:57, Fernando D. Bozzo fdbo...@gmail.com wrote:
This link on my GDrive, should be like your link on yours. Open it and look
Hi Laurie:
I am looking at your zip, but didn't find the structure of the DBC you are
talking on your first post.
Can you generate the text version of the .DBC (will be .*DC2*), upload the
new zip and copy the new link here?
Thanks.-
2014-10-01 10:02 GMT+02:00 Laurie Alvey
Sorry, I'm thoroughly confused. I've opened readme.txt and I'm not sure
what's meant by create a shortcut in the SendTo folder. What should I
set as the target?
Also, I have the members.dc2 file in a separate folder - what do you want
me to do with it and do you need all the table structures as
Hi Laurie:
When you choose a directory for FoxBin2Prg project, lets say c:\foxbin2prg,
you need to create showrtcuts for all the .VBS files (select all .vbs,
right-click, create shortcuts) and then, move those shortcuts to the SendTo
folder (and renaming to cut off the shrotcut to words included
Just in case:
Your SendTo folder is located ander your user profile:
C:\Documents and Settings\YOUR-USER\SendTo
or similar.
Regards.-
2014-09-30 11:19 GMT+02:00 Fernando D. Bozzo fdbo...@gmail.com:
Hi Laurie:
When you choose a directory for FoxBin2Prg project, lets say
c:\foxbin2prg,
Thank you for all your help. All db2 and dc2 files are in the attached file.
Laurie
On 30 September 2014 10:21, Fernando D. Bozzo fdbo...@gmail.com wrote:
Just in case:
Your SendTo folder is located ander your user profile:
C:\Documents and Settings\YOUR-USER\SendTo
or similar.
I can't see the attach, anyone can see it?
2014-09-30 13:04 GMT+02:00 Laurie Alvey trukke...@gmail.com:
Thank you for all your help. All db2 and dc2 files are in the attached
file.
Laurie
--- StripMime Report -- processed MIME parts ---
multipart/mixed
multipart/alternative
This list seems to not admit attached files. May be better upload on google
drive: create a public folder on GD, upload the zip in that folder and
share the link of the file in this list.
2014-09-30 13:04 GMT+02:00 Laurie Alvey trukke...@gmail.com:
Thank you for all your help. All db2 and
Fernando D. Bozzo wrote:
This list seems to not admit attached files. May be better upload on google
drive: create a public folder on GD, upload the zip in that folder and
share the link of the file in this list.
Yes, you can't send attachements to the list.
Peter
I've created a folder on Google Drive called LauriePublic. I've set the
folder as shared but as I've never done this before, I've hope I've done it
right.
Laurie
On 30 September 2014 12:45, Peter Cushing pcush...@whisperingsmith.com
wrote:
Fernando D. Bozzo wrote:
This list seems to not
The file is called processed.zip. If the upload hasn't worked, perhaps I
could send it directly to your email.
Laurie
On 30 September 2014 13:49, Laurie Alvey trukke...@gmail.com wrote:
I've created a folder on Google Drive called LauriePublic. I've set the
folder as shared but as I've never
Hi Laurie:
This is half of the road :)
For sharing a file, you need to go to your GD, right click on the file,
select Show link (or similar), copy this link and paste here.
2014-09-30 14:49 GMT+02:00 Laurie Alvey trukke...@gmail.com:
I've created a folder on Google Drive called
I'm running XP Pro. Can't find anything similar to Show Link. Any ideas?
Laurie
On 30 September 2014 14:24, Fernando D. Bozzo fdbo...@gmail.com wrote:
Hi Laurie:
This is half of the road :)
For sharing a file, you need to go to your GD, right click on the file,
select Show link (or
Would be more useful if you enumerate the options you see on the zip file
in Google Drive
It's not complicated at all
El 30/09/2014 17:33, Laurie Alvey trukke...@gmail.com escribió:
I'm running XP Pro. Can't find anything similar to Show Link. Any ideas?
Laurie
On 30 September 2014 14:24,
There's quite a few. I'll get back yo you.
Laurie
On 30 September 2014 16:36, Fernando D. Bozzo fdbo...@gmail.com wrote:
Would be more useful if you enumerate the options you see on the zip file
in Google Drive
It's not complicated at all
El 30/09/2014 17:33, Laurie Alvey
This link on my GDrive, should be like your link on yours. Open it and look
at the picture of the menu I'm talking about.
https://drive.google.com/file/d/0B_qHXcWqGDY-ZkVFdVNfbi0xbEk/view?usp=sharing
A link like this is what you need to post here.
Regards.-
2014-09-30 18:09 GMT+02:00 Laurie
This gets worse. I've downloaded the foxbin2prg stuff and unzipped it to
c:\foxbin2prg. I then opened VFP, navigated to the foxbin2prg folder and
issued this:
DO foxbin2prg.prg WITH c:\club\data\members.dbc. Result - File does not
exist.
What am I doing wrong?
Laurie
On 28 September 2014 11:12,
Without seen it, I just can think on what the message says, that the
path+filename have something wrong, but to be sure, you can install the
included scripts as explained in readme.txt and then right-click on the dbc
and sent to FoxBin2Prg (shortcuts of the scripts must be copied in sendto
folder,
I get the File does not exist message in the status bar. And yes, I
unzipped the whole zip file.
Laurie
On 29 September 2014 10:08, Fernando D. Bozzo fdbo...@gmail.com wrote:
Without seen it, I just can think on what the message says, that the
path+filename have something wrong, but to be
And did you have used the scripts?
El 29/09/2014 12:10, Laurie Alvey trukke...@gmail.com escribió:
I get the File does not exist message in the status bar. And yes, I
unzipped the whole zip file.
Laurie
On 29 September 2014 10:08, Fernando D. Bozzo fdbo...@gmail.com wrote:
Without seen
Have you looked in the c:\club\data\ folder for the file members.dc2 ?
Gianni
On Mon, 29 Sep 2014 11:10:04 +0100, Laurie Alvey trukke...@gmail.com wrote:
I get the File does not exist message in the status bar. And yes, I
unzipped the whole zip file.
Laurie
On 29 September 2014 10:08, Fernando
I mean that this should be the result of FoxBin2Prg.
HTH,
Gianni
On Mon, 29 Sep 2014 14:34:02 +0200, Gianni Turri gianni...@gmail.com wrote:
Have you looked in the c:\club\data\ folder for the file members.dc2 ?
Gianni
On Mon, 29 Sep 2014 11:10:04 +0100, Laurie Alvey trukke...@gmail.com
Yes, it's there (members.dc2). No, I didn't use the scripts because I
didn't understand what I was supposed to do and I don;t speak Spanish. What
should I do now?
Laurie
On 29 September 2014 15:17, Gianni Turri gianni...@gmail.com wrote:
I mean that this should be the result of FoxBin2Prg.
Laurie, the first part of the readme.txt is in English
Did you try to open it?
El 29/09/2014 16:56, Laurie Alvey trukke...@gmail.com escribió:
Yes, it's there (members.dc2). No, I didn't use the scripts because I
didn't understand what I was supposed to do and I don;t speak Spanish. What
This is weird. Issuing DBGETPROP() against the Northwind database works
correctly - on my database it doesn't. I've checked the file versions and
they both have 0x30 at byte 0 so it isn't that.
Laurie
On 27 September 2014 15:30, AndyHC jarnd...@gmail.com wrote:
On 27/09/2014 09:44, Laurie
Hi Laurie:
Can you use FoxBin2Prg https://vfpx.codeplex.com/wikipage?title=FoxBin2Prg
to generate text versions of your tables and DBCs (just structures, no
data), and publish them so we can analyze them?
The generated files are .db2 for the tables and .dc2 for the databases.
2014-09-28 10:22
I don't think you can update more than one table from a view, but that
wasn't why I wanted a list of tables. What I wanted to do was copy the
field captions from the tables to the corresponding view fields without
having to do it in the view designer. I've got round it by writing a
function to
On Thu, Sep 25, 2014 at 7:00 AM, Laurie Alvey trukke...@gmail.com wrote:
When I issue ? DBGETPROP(somelocalview,VIEW,Tables) it only ever
shows one table even when the view has 3 or 4 tables in its definition. The
VFP Help file says the function returns a comma delimited list.. The tables
are
Hi Laurie:
I've tested it, and your DBGETPROP returns all tables for me.
I've made a new database (NW.DBC) and a local view (orders_by_customer)
using Northwind orders and customers tables from Samples directory,
selecting 3 fields of each table, then:
*1) Get tables from the view:*
?
On 27/09/2014 09:44, Laurie Alvey wrote:
I don't think you can update more than one table from a view
see http://msdn.microsoft.com/en-US/library/f5scy1hs%28v=vs.80%29.aspx
Updating multiple tables in a view.
Personally I wouldn't try it without using makeupdatable() - from Paul
McNett
Should match the
DBSETPROP(somelocalview,VIEW,Tables, ...)
that you have in the view definition code
if you use the view designer, you need to select 'display SQL' to view this code
never updated several tables with a single view.
Thierry Nivelet
FoxinCloud
Give your VFP app a new life in the
When I issue ? DBGETPROP(somelocalview,VIEW,Tables) it only ever
shows one table even when the view has 3 or 4 tables in its definition. The
VFP Help file says the function returns a comma delimited list.. The tables
are linked using the JOIN syntax and I wonder if this is confusing the Fox.
51 matches
Mail list logo