This command:
SWITCH (.RBTI_FORM_MODE)
now produces these error messages:
Column or variable RBTI_Form_Mode not found 2515
Switch Expression must be integer or text
As far as I know it was working in v9.5 and I think before the latest
update.
The variable is NOT included in the help
=
cRaceID TEXT
Albert
On 2016-06-15 11:10 AM, Alastair Burr wrote:
This command:
SWITCH (.RBTI_FORM_MODE)
now produces these error messages:
Column or variable RBTI_Form_Mode not found 2515
Switch Expression must be integer or text
As far as I know
Does anyone know what might cause the above error from the connect command?
The database seems to connect despite the message and, clearly there are
columns:
Database statistics:
Table entries allocated: 454 Table entries in use: 131
Table entry utilization 28.8546255506608%
For what it's worth:
Over the last 6-8 weeks or so I have been having problems with my
(uncompiled & single user) backup routine which inserts data to one
database as it backs up other databases.
With RBase v9.5 and Windows 10 this suddenly started being a problem with an
RMD file that
since. A client is having similar
problems, so we will try the same thing. This happened with a Windows 10
Pro update two or three weeks ago.
Albert
On 2016-04-08 5:51 AM, Alastair Burr wrote:
For what it's worth:
Over the last 6-8 weeks or so I have been having problems with my
(uncompiled
en says ...and so on through %9 - is there a
contradiction there or am I missing something else?
Thanks & regards,
Alastair.
-Original Message-
From: Alastair Burr
Sent: Sunday, May 8, 2016 8:55 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Can anybody explain this:
Thanks Razzak, I'll read pr
ANSI
This is new syntax to accommodate both ANSI and UTF-8 encoding schemes.
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Bur
that one of view column aliases is the same as a column name in some other
table with a different datatype.
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com]
has full access.
Regards,
Alastair.
On 31/01/2017 10:07, Alastair Burr wrote:
Thanks Javier,
Yes, I've tried those but my problem is trying to get NO password:
If I recreate all 5 of my databases which all use the same owner and logins and
start with:
CREATE SCHEMA AUTHORIZATION Books XYZ
and t
for the identifier
If you enter Alistair it should go straight in
If that works, go to Razzak's fte site and read the whole way of running SQL
Access control
Albert
On Jan 31, 2017, at 7:41 AM, Alastair Burr
<adbb...@outlook.com<mailto:adbb...@outlook.com>> wrote:
Just to add to this:
This is the scenario:
I set trace on at R:>
EDIT USING [Form] WHERE ...
On row entry EEP: no errors
Last line: RETURN
Press [F10]
-ERROR- Expression does not return a valid TIME. 2158
Click [OK]
Error message reappears 3 times then:
Runtime Error!
Program C:\...\RBGX.EXE
R6030
- CRT not
,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 1:17 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googleg
<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-04-17 6:30 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD
Thanks,
Unfortunately and desp
At last: success: I now have all 5 of my databases with the same users and the
same owner and no passwords.
The way I have been able to get there was by UNLOADing each one and changing
the database owner name in the output file and giving it a different password
there.
I added in a SET USER
arkson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 1:31 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [
Hopefully an easier one:
I noticed and "corrected" the following line in the output files from all my
unloads yesterday:
SET CURRENCY '£' PREF 2 B
which I changed to:
SET CURRENCY '£' PREF 2 B
but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple
I think, "technically" you DELete records from a database and ERASE files from
the directory/folder.
I usually make sure that I have the DOS command correct and then in R:Base
create a variable & activate that:
SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
and
SET VAR vEraseFile TEXT =
that provides you with some blue's clues ...
Very Best R:egards,
Razzak
At 09:41 AM 1/24/2017, Alastair Burr wrote:
Thanks, but does not seem to be the answer.
However, you did remind me that images can be included.
The first below is as the form opens and the second the result of clicking
size. Test to make the rows one or two pixel
higher or to reduce the font size by one pixel.
Does it make a difference?
Regards
Adrian
Von: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] Im Auftrag von Alastair Burr
Gesendet: Dienstag, 24.
I know it's Friday but can anybody see what's wrong with this view (an image so
that hopefully the email system doesn't mangle my layout):
If it hasn't, there should be 6 columns so that I could see the columns and
data types (first 5 rows remmed out) more easily.
I am not sure that I am
harmacy Examining Board of Canada
416.979.2431 x251
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: January-27-17 12:52 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [R
TABLE Columns and View
Columns. The LIST COLUMNS command only shows info on Table columns not view
columns.
Jim Bentley, American Celiac Society 1-504-305-2968
From: Alastair Burr <adbb...@outlook.com><mailto:adbb...@outlook.com>
To: "rbase-l
Create a (temp) table?
Regards,
Alastair.
On 16/02/2017 16:26, Bruce Chitiea wrote:
Thanks, Karen.
That's pretty much what I've been doing. I've been stepping through
incrementing values within nested loops, or using a loop inside a cursor.
Just wondering how one might replace that "inside"
:
Could be the row focus colors?
[cid:part2.3EA75CAD.37F52AEB@outlook.com]
Dan Goldberg
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Tuesday, January 24, 2017 4:35 AM
To: R:Base Listserver 2016
&l
Create a temp table/view or a permanent column with the conversion you need?
Regards,
Alastair.
On 19/08/2016 20:29, karentellef via RBASE-L wrote:
Yeah, but how would I display a variable in a list view? And I can't
really define a form variable because the table that the variable
lookup
Albert,
I have a RMD program that gives me various levels of access and this what I
have used up v10:
GRANT SELECT ON `SYS_Defaults` TO PUBLIC,
GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts3` TO PUBLIC,
GRANT SELECT, INSERT, UPDATE ON
Albert,
Just a thought:
When I worked in different countries in Europe, national keyboards were often
the problem when some characters went "astray". Often the answer was to use the
key in the position of the UK or perhaps more often the US keyboard position.
I know nothing about Macs but if
Can anybody see anything wrong with this:
SET VAR vFilePathName TEXT = NULL
GETPROPERTY ID_FileName SHORTFILENAME vFilePathName
File List Box On Click custom EEP
Ver: 10.0.2.20307
Both that and LongFileName both resolutely stay null through tracing.
Equivalent code for Directory in Directory
SET ETHEREAL_SOUNDS ON, maybe?
Regards,
Alastair.
On 21/04/2017 18:52, Bill Downall wrote:
I have an app that was converted to a cloud app recently.
We just noticed that sounds that have always alerted people to data entry
issues no longer sound on the local computer. I presume if anyone were
Karen,
This is the sort of time when it could be useful to be able to see TRACE
scrolling through on screen when running to next error or, in your case just
running to the end. You might then be able to see where it slows down or takes
time over a particular line.
Regards,
Alastair.
On
Karen,
I may be well wide of the mark if I haven't twigged what you're after properly
but I think I would start along these lines:
Project a temp table that contains all the matches for policy/company.
Add a flag column defaulted to 1 (only one criteria matched);
Then use your code to reset the
For some reason this went direct to Mike rather than the list.
Forwarded Message
Subject:Re: [RBASE-L] - Password error
Date: Wed, 14 Jun 2017 17:02:25 +0100
From: Alastair Burr <adbb...@outlook.com><mailto:adbb...@outlook.com>
Reply-To: adbb...
elf: what does the word "AUTHOR" mean? Is
that always there, or does it mean something?
Karen
-Original Message-
From: Alastair Burr <adbb...@outlook.com><mailto:adbb...@outlook.com>
To: R:Base Listserver 2016
<rbase-l@googlegroups.com><mailto:rbase-l@goo
Again, this went to Mike from my reply button - apologies.
Forwarded Message
Subject:Re: [RBASE-L] - Password error
Date: Fri, 16 Jun 2017 16:48:29 +0100
From: Alastair Burr <adbb...@outlook.com><mailto:adbb...@outlook.com>
Reply-To: adbb...
A few days ago I replied to Dan Goldberg using the reply button in my e-mail
software (Mozilla Thunderbird) and then later wondered why I hadn't had the
message returned to me as usual via the list.
This has happened a few times and I have simply re-posted my post if it was
still relevant.
This didn't seem to appear yesterday:
Forwarded Message
Subject:Re: [RBASE-L] - Elapsed time in HH:MM format
Date: Sat, 13 Jan 2018 08:35:52 +
From: Alastair Burr <adbb...@outlook.com><mailto:adbb...@outlook.com>
Reply-To: adbb...@outlook.com
On Monday, April 16, 2018, 6:44:53 PM GMT+5, Alastair Burr
<adbb...@outlook.com><mailto:adbb...@outlook.com> wrote:
Do you have COLCHECK set to ON to specify checking?
Regards,
Alastair.
On 16/04/2018 13:08, 'rehan wyne' via RBASE-L wrote:
Hello All,
I have defined all controlled c
Do you have COLCHECK set to ON to specify checking?
Regards,
Alastair.
On 16/04/2018 13:08, 'rehan wyne' via RBASE-L wrote:
Hello All,
I have defined all controlled column names and their data types in
"controlled_column_names table", that will be enforced in creating a view when
using
And if that doesn't work try double quotes in the variable:
set var vfilename text = ' "c:\program files\test.pdf " ' -- I've put a space
to make them show up, the spaces are not needed.
IF that doesn't work, I've found creating a variable for the path and another
for the name does:
set var
Try the function: (CTXT(arg))
Regards, Alastair
On 29/01/2021 05꞉41, 'R Hopkins' via RBASE-L wrote:
Dan,
Here is another technique for a converting variable of type time to
a vaiable of type text, and it is very simple.
SET VAR vtime TIME = 10:11:22
SET VAR vtxt TEXT = --This
Would connecting to Outlook on- line in a Web Browser control on a form
allow drag and drop?
Regards,
Alastair.
On 24/06/2021 14꞉58, Dan Goldberg wrote:
Thx never done it from another program before. Sure there is a way as
other programs allow this.
Dan Goldberg
*From:*
Facebook has been uninstalled and deleted from my devices and will not
be reinstalled.
I use No Script to keep its insidious scripts at bay.
Enough said,
Alastair.
On 14/12/2021 19꞉51, A. Razzak Memon wrote:
Tuesday, December 14, 2021
Dear R:BASE Community,
We all know first-hand the
Dan, try ADDDAY:
set var vIntweeks = 8 (or whatever)
(ADDDAY(.vdate, (.vIntweeks * 7) ))
Use -7 to go back in time
Regards, Alastair.
On 10/03/2022 15꞉19, Dan Goldberg wrote:
I have a need to add 8 weeks to a date variable. I looked and noticed
there is not an addwk function like addday
Looks to me that you have a space, just before AM - possibly due to
date/time format change. Filenames with spaces need to be in double
quotes for system copy.
Rwgards. Alastair.
On 26/06/2023 15:01, 'jim schmitt' via RBASE-L wrote:
Good Moring, group:
I have a Utility Billing program
anks, Alastair:
Yes, there are three spaces in the VF_TO variable, but isn't the
'cannot open source file' referring to the 'C:\UBILL\*.*' of the copy
command ?
Still searching. Jim
On Monday, June 26, 2023 at 10:50:22 AM EDT, Alastair Burr
wrote:
Looks to me that you have a space, just
45 matches
Mail list logo