I have two DBC's with the same file name in them. Everything works okay
except for checking if a specific file is being used().
Example:
open database dbc1
set database to dbc1
use dbc1.filename
open database dbc2
set database to dbc2
?used('filename') returns .t
On 1/24/2012 11:40 AM, Jeff Johnson wrote:
>
> I have two DBC's with the same file name in them. Everything works okay
> except for checking if a specific file is being used().
>
> Example:
> open database dbc1
> set database to dbc1
> use dbc1.filename
>
> open database db
Jeff Johnson wrote on 2012-01-24:
>
> I have two DBC's with the same file name in them. Everything works okay
> except for checking if a specific file is being used().
>
> Example:
> open database dbc1
> set database to dbc1
> use dbc1.filename
>
> open databa
WAG - can you qualify the filename with the dbc name? IF
USED(dbc2.filename)
John Weller
01380 723235
07976 393631
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf
> Of Jeff Johnson
> Sent: 24 January 2012 16:41
> To: profoxt...@
You could use DBF('filealias') and check the path and presumably that
will show the difference.
HTH
* Peter Cushing *
IT development and support
Signature
Jeff Johnson wrote:
> I have two DBC's with the same file name in them. Everything works okay
> except for checking if a specific file i
Jeff,
I'm pretty sure that CURSORGETPROP function can give you that answer. I
know I've done it, but not handy with code now as I haven't done programming
for years. But I'm sure it'll do it.
Wally Noll
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com]
On 01/24/2012 09:53 AM, Tracy Pearson wrote:
> Jeff Johnson wrote on 2012-01-24:
>> I have two DBC's with the same file name in them. Everything works okay
>> except for checking if a specific file is being used().
>>
>> Example:
>>open database dbc1
>>set database to dbc1
>>
What I meant is that CURSORGETPROP has that DataBase property, you can test
each dbf and find what DBC it belongs to. I think I had the same exact
problem once.
Wally Noll
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Wally Noll
Sent: Tu
On 01/24/2012 10:10 AM, Wally Noll wrote:
> What I meant is that CURSORGETPROP has that DataBase property, you can test
> each dbf and find what DBC it belongs to. I think I had the same exact
> problem once.
>
> Wally Noll
>
> -Original Message-
> From: profox-boun...@leafe.com [mailto:p
I use the VMP framework mostly authored by Drew Speedie. Look what I
found in the documentation:
"Since VFP allows you to have more than one .DBC/database open at once,
and each database could have its own GeneratePK table, the fact that
used("GeneratePK") isn't good enough -- we have to make su
MySQL (well, actually MariaDB via HeidiSQL IDE)
For some reason, I'm having a problem getting a field cast as a varchar in
my sql. I'm trying this:
select CAST('test' as varchar(255));
...and it fails saying I have an error in syntax. I can do this just fine:
select CAST('test' as char(255));
Don't know if this has changed (apparently not)
http://bugs.mysql.com/bug.php?id=34564
--
rk
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of MB Software Solutions General Account
Sent: Tuesday, January 24, 2012 1:06 PM
To: profox
Doing 'OK' Jeff, thanks for your interest. Have been reading this forum for
a while and I will be picking up skills again.
Thanks, Wally.
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Jeff Johnson
Sent: Tuesday, January 24, 2012 10:17 AM
On Tue, January 24, 2012 1:11 pm, Richard Kaye wrote:
> Don't know if this has changed (apparently not)
>
>
> http://bugs.mysql.com/bug.php?id=34564
>
Thanks, Richard. Looks like I'll have to stick with CHAR for now. I'm
using SQL Server scripts from a previous developer, and it's a PITA to
ha
>
> WTF?!?!? On more tests, it seems that I can't get it to cast to
VARCHAR
> or FLOAT types.
>
Well, let me ask the dumb question - does Maria (some day I should tell
you about my ex Maria - oh boy...) DB support the VARCHAR syntax in the
first place? Do you use that syntax anywhere else in y
On Tue, January 24, 2012 1:19 pm, Jarvis, Matthew wrote:
> Well, let me ask the dumb question - does Maria (some day I should tell
> you about my ex Maria - oh boy...) DB support the VARCHAR syntax in the
> first place? Do you use that syntax anywhere else in your
> testing/application?
Hi Matt,
Le 24/01/2012 17:40, Jeff Johnson a écrit :
> Please don't suggest that I change the file name.
But what about using an alias ?
USE dbc1!filename AS filename1 IN 0
USE dbc2!filename AS filename2 IN 0
? USED(filename1)
? USED(filename2)
The foxil
__
A fundamental question that I hope I can get some help with.
Can I establish and ODBC connection using VFP9 to Oracle 10g and 14g
on the same machine. Have looked at the Oracle site and am very
confused with the array of ODBD's available
Can someone point me in a better direction
Regard
On Tue, January 24, 2012 3:45 pm, Jean MAURICE wrote:
> Le 24/01/2012 17:40, Jeff Johnson a écrit :
>
>> Please don't suggest that I change the file name.
>>
>
> But what about using an alias ?
>
>
> USE dbc1!filename AS filename1 IN 0
> USE dbc2!filename AS filename2 IN 0
> ? USED(filename1)
> ? U
On Tue, January 24, 2012 4:09 pm, Desmond Lloyd wrote:
> A fundamental question that I hope I can get some help with.
>
>
> Can I establish and ODBC connection using VFP9 to Oracle 10g and 14g
> on the same machine. Have looked at the Oracle site and am very confused
> with the array of ODBD's ava
On 01/24/2012 01:45 PM, Jean MAURICE wrote:
> Le 24/01/2012 17:40, Jeff Johnson a écrit :
>> Please don't suggest that I change the file name.
> But what about using an alias ?
>
> USE dbc1!filename AS filename1 IN 0
> USE dbc2!filename AS filename2 IN 0
> ? USED(filename1)
> ? USED(filename2)
>
>
On Tue, Jan 24, 2012 at 1:19 PM, Jarvis, Matthew wrote:
> Well, let me ask the dumb question - does Maria (some day I should tell
> you about my ex Maria - oh boy...) DB support the VARCHAR syntax in the
> first place? Do you use that syntax anywhere else in your
> testing/application?
There are
Stumbled across this just this morning
http://code.google.com/intl/en/webtoolkit/gettingstarted.html
Usable, or overkill?
Thanks,
Matthew Jarvis || Business Systems Analyst
IT Department
McKenzie-Willamette Medical Center
1460 G Street, Springfield, OR 97477 || Ph: 541-744-6
On 1/24/12 2:37 PM, Jarvis, Matthew wrote:
> Stumbled across this just this morning
>
> http://code.google.com/intl/en/webtoolkit/gettingstarted.html
>
> Usable, or overkill?
I haven't used it deeply, but was briefly involved with a startup to run Dabo
apps
through a browser, using GWT for t
24 matches
Mail list logo