date:20170807

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins

Buddy,

Truth be told I messed up big time.  I’m going blind looking at these 
variables…  I used vlading where the variable name is vlad… My apologies for 
leading you astray.

Now, everything is working fine.

Thank you very much,

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Monday, August 07, 2017 7:35 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Claudine
  I would add ‘INT’ before the (vlading) when building your variable

SET VAR vValue = (.vValue + ', INT(' + ('.Vlading' +(CTXT(.VCOUNT)))+’)’ )

I think I have the it added in (RED) the right spot

Buddy

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Monday, August 7, 2017 8:03 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Trying to figure this out on my own.  I tried one field at a time and all load 
fine until I reach vlading.  All text fields total 667 characters.  Am I 
running up against a size limit of some kind?

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Monday, August 07, 2017 6:17 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Oh, it helps a lot.  And what a beautiful thing it is when code works as 
expected!

One problem remains however, on the last field loaded I get an error 122 that 
LOADLADING needs to be TEXT.  Except for vamt which is currency, the variables 
and the temp table column are text so I’m stumped.  This is my code:

SET VAR vValue TEXT

SET VAR vValue = ('.VDTG'+(CTXT(.VCOUNT)))

SET VAR vValue = (.vValue + ',' + ('.Vcar'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vwb'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vamt'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vorigin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vdestin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vlading' +(CTXT(.VCOUNT))) )

INSERT INTO comparecontrast 
(LOADDTGSPLIT,LOADCARNAME,LOADWB,CARAMT,LOADORIGIN,LOADDESTIN,LOADLADING) 
VALUES 

vValue = .VDTG1,.Vcar1,.Vwb1,.Vamt1,.Vo   TEXT

 rigin1,.Vdestin1,.Vlading1

Vlad1  = LOAD FROM SEABOARD-CORPUS:   TEXT

 [1] 5-1/8" X 15 MANUAL VALVE,

 BOLTS, RING GASKETS  ***

-Original Message-
From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Sunday, August 06, 2017 10:39 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Razzak,

Well I can't wait to try it tomorrow!  I actually also have several values to 
load into my temp table...

Thank you very much.

Claudine

Sent from my iPhone

On Aug 6, 2017, at 8:23 PM, A. Razzak Memon 
> wrote:

Claudine,

The timing of your post couldn't have been better.

Yes, you can!

In your specific case ...

You will have to create an additional variable to build the string which is the 
"values" part of the insert.

When you finally go to use that variable, use the "&" prefix instead of the "." 
prefix.

Here is the key part of an example from one of my application ...

-- Predefined variables and logic is defined here ...

SET VAR vValue TEXT

WHILE vWorkingOn <> vLFNFileCount THEN

  SET VAR vWorkingOn = (.vWorkingOn + 1)

  SELECT (MAX(External_File_ID)+1) INTO vExternal_File_ID INDIC iv1 FROM 
External_Files

  -- Build the string with needed file names

  set var vValue = ('(' + '.vExternal_File_ID')

  set var vValue = (.vValue + ',' + '.vLFNFileNameS' + CTXT(.vWorkingOn))

  set var vValue = (.vValue + ',' + '.vLFNFileExt'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileDateTime'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileSize'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFilePath'+(CTXT(.vWorkingOn)) + ')')

  -- Now use this string for the value part of the insert

  INSERT INTO External_Files +

  (External_File_ID, +

   External_File_Name, +

   External_File_Extension, +

   External_File_DateTime, +

   External_File_Size, +

   External_File_Original_Path) +

  VALUES +

ENDWHILE

RETURN

Hope that helps!

Very Best R:egards,

Razzak

At 09:05 PM 8/6/2017, Claudine Robbins wrote:

> SET VAR VCOUNT = 1

> SET VAR yylading TEXT = ('Vlad'+(CTXT(.VCOUNT)))vlad1 SET VAR

>  TEXT = NULL-same as vlad1 = NULL SELECT LADING INTO

>  INDICATOR ivlad FROM orders WHERE (dtg+split) = .ventry

> R>sho

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins

Thank you very much.  It's working!  I'm happy, at least until tomorrow :-)

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Monday, August 07, 2017 7:56 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Claudine,

In addition to Buddy's observation, you may pre-define the vValue as NOTE or 
VARCHAR data type.

Very Best R:egards,

Razzak

At 08:02 PM 8/7/2017, Claudine Robbins wrote:

>Trying to figure this out on my own.  I tried one field at a time and 
>all load fine until I reach vlading.  All text fields total 667 
>characters.  Am I running up against a size limit of some kind?
>
>From: rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
>Sent: Monday, August 07, 2017 6:17 PM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables
>
>Oh, it helps a lot.  And what a beautiful thing it is when code works 
>as expected!
>
>One problem remains however, on the last field loaded I get an error 
>122 that LOADLADING needs to be TEXT.  Except for vamt which is 
>currency, the variables and the temp table column are text so Iâ€™m 
>stumped.  This is my code:
>
>SET VAR vValue TEXT
>SET VAR vValue = ('.VDTG'+(CTXT(.VCOUNT))) SET VAR vValue = (.vValue + 
>',' + ('.Vcar'+(CTXT(.VCOUNT))) ) SET VAR vValue = (.vValue + ',' + 
>('.Vwb'+(CTXT(.VCOUNT))) ) SET VAR vValue = (.vValue + ',' + 
>('.Vamt'+(CTXT(.VCOUNT))) ) SET VAR vValue = (.vValue + ',' + 
>('.Vorigin'+(CTXT(.VCOUNT))) ) SET VAR vValue = (.vValue + ',' + 
>('.Vdestin'+(CTXT(.VCOUNT))) ) SET VAR vValue = (.vValue + ',' + 
>('.Vlading' +(CTXT(.VCOUNT))) ) INSERT INTO comparecontrast
>(LOADDTGSPLIT,LOADCARNAME,LOADWB,CARAMT,LOADORIGIN,LOADDESTIN,LOADLADIN
>G)
>VALUES 
>
>vValue = .VDTG1,.Vcar1,.Vwb1,.Vamt1,.Vo   TEXT
>  rigin1,.Vdestin1,.Vlading1
>Vlad1  = LOAD FROM SEABOARD-CORPUS:   TEXT
>  [1] 5-1/8" X 15 MANUAL VALVE,
>  BOLTS, RING GASKETS  ***
>
>
>-Original Message-
>From: 
>rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
>Sent: Sunday, August 06, 2017 10:39 PM
>To: rbase-l@googlegroups.com
>Subject: Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables
>
>Razzak,
>Well I can't wait to try it tomorrow!  I actually also have several 
>values to load into my temp table...
>Thank you very much.
>Claudine
>Sent from my iPhone
>
>On Aug 6, 2017, at 8:23 PM, A. Razzak Memon 
><raz...@rbase.com> wrote:
>
>Claudine,
>
>The timing of your post couldn't have been better.
>
>Yes, you can!
>
>In your specific case ...
>
>You will have to create an additional variable to build the string 
>which is the "values" part of the insert.
>
>When you finally go to use that variable, use the "&" prefix instead of 
>the "." prefix.
>
>Here is the key part of an example from one of my application ...
>
>-- Predefined variables and logic is defined here ...
>SET VAR vValue TEXT
>WHILE vWorkingOn <> vLFNFileCount THEN
>   SET VAR vWorkingOn = (.vWorkingOn + 1)
>   SELECT (MAX(External_File_ID)+1) INTO  vExternal_File_ID INDIC iv1 
>FROM External_Files
>   -- Build the string with needed file names
>   set var vValue = ('(' + '.vExternal_File_ID')
>   set var vValue = (.vValue + ',' + '.vLFNFileNameS' + CTXT(.vWorkingOn))
>   set var vValue = (.vValue + ',' + '.vLFNFileExt'+(CTXT(.vWorkingOn)))
>   set var vValue = (.vValue + ',' + '.vLFNFileDateTime'+(CTXT(.vWorkingOn)))
>   set var vValue = (.vValue + ',' + '.vLFNFileSize'+(CTXT(.vWorkingOn)))
>   set var vValue = (.vValue + ',' +
> '.vLFNFilePath'+(CTXT(.vWorkingOn)) + ')')
>   -- Now use this string for the value part of the insert
>   INSERT INTO External_Files +
>   (External_File_ID, +
>External_File_Name, +
>External_File_Extension, +
>External_File_DateTime, +
>External_File_Size, +
>External_File_Original_Path) +
>   VALUES +
>
>ENDWHILE
>RETURN
>
>Hope that helps!
>
>Very Best R:egards,
>
>Razzak
>
>At 09:05 PM 8/6/2017, Claudine Robbins wrote:
>
> > SET VAR VCOUNT = 1
> > SET VAR yylading TEXT = ('Vlad'+(CTXT(.VCOUNT)))vlad1 SET VAR 
> >  TEXT = NULL-same as vlad1 = NULL SELECT LADING INTO 
> >  INDICATOR ivlad FROM orders WHERE (dtg+split) = .ventry
> > R>sho v vlad1
> > LOAD FROM SEABOARD-CORPUS:
> > [1] 5-1/8" X 15 MANUAL VALVE,
> > BOLTS, RING GASKETS  ***
> > LOAD FROM BASIC
> > ENERGY-CORPUS:  [1] 5-1/8" X
> > 15 MANUAL VALVE, BOLTS, RING
> > GASKETS
> >
> > Iâ€™m trying to do something which is NOT in
> the whitepaper dotted vs. ampersand variables.
> >
> > Iâ€™m in a 4 count while loop, so as vcount
> is incremented field vlad becomes vlad1, vlad2, vlad3, and vlad4.
> >
> > My select correctly acquires the lading
>

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Buddy Walker

Claudine

  I would add ‘INT’ before the (vlading) when building your variable

SET VAR vValue = (.vValue + ', INT(' + ('.Vlading' +(CTXT(.VCOUNT)))+’)’ )

I think I have the it added in (RED) the right spot 

Buddy

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Monday, August 7, 2017 8:03 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Trying to figure this out on my own.  I tried one field at a time and all load 
fine until I reach vlading.  All text fields total 667 characters.  Am I 
running up against a size limit of some kind?

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Monday, August 07, 2017 6:17 PM
To: rbase-l@googlegroups.com  
Subject: RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Oh, it helps a lot.  And what a beautiful thing it is when code works as 
expected!

One problem remains however, on the last field loaded I get an error 122 that 
LOADLADING needs to be TEXT.  Except for vamt which is currency, the variables 
and the temp table column are text so I’m stumped.  This is my code:

SET VAR vValue TEXT

SET VAR vValue = ('.VDTG'+(CTXT(.VCOUNT)))

SET VAR vValue = (.vValue + ',' + ('.Vcar'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vwb'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vamt'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vorigin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vdestin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vlading' +(CTXT(.VCOUNT))) )

INSERT INTO comparecontrast 
(LOADDTGSPLIT,LOADCARNAME,LOADWB,CARAMT,LOADORIGIN,LOADDESTIN,LOADLADING) 
VALUES 

vValue = .VDTG1,.Vcar1,.Vwb1,.Vamt1,.Vo   TEXT

 rigin1,.Vdestin1,.Vlading1

Vlad1  = LOAD FROM SEABOARD-CORPUS:   TEXT

 [1] 5-1/8" X 15 MANUAL VALVE,   

 BOLTS, RING GASKETS  ***

-Original Message-
From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Sunday, August 06, 2017 10:39 PM
To: rbase-l@googlegroups.com  
Subject: Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Razzak,

Well I can't wait to try it tomorrow!  I actually also have several values to 
load into my temp table...

Thank you very much. 

Claudine

Sent from my iPhone

On Aug 6, 2017, at 8:23 PM, A. Razzak Memon <  
raz...@rbase.com> wrote:

Claudine,

The timing of your post couldn't have been better.

Yes, you can!

In your specific case ...

You will have to create an additional variable to build the string which is the 
"values" part of the insert.

When you finally go to use that variable, use the "&" prefix instead of the "." 
prefix.

Here is the key part of an example from one of my application ...

-- Predefined variables and logic is defined here ...

SET VAR vValue TEXT

WHILE vWorkingOn <> vLFNFileCount THEN

  SET VAR vWorkingOn = (.vWorkingOn + 1)

  SELECT (MAX(External_File_ID)+1) INTO vExternal_File_ID INDIC iv1 FROM 
External_Files

  -- Build the string with needed file names

  set var vValue = ('(' + '.vExternal_File_ID')

  set var vValue = (.vValue + ',' + '.vLFNFileNameS' + CTXT(.vWorkingOn))

  set var vValue = (.vValue + ',' + '.vLFNFileExt'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileDateTime'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileSize'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFilePath'+(CTXT(.vWorkingOn)) + ')')

  -- Now use this string for the value part of the insert

  INSERT INTO External_Files +

  (External_File_ID, +

   External_File_Name, +

   External_File_Extension, +

   External_File_DateTime, +

   External_File_Size, +

   External_File_Original_Path) +

  VALUES +

ENDWHILE

RETURN

Hope that helps!

Very Best R:egards,

Razzak

At 09:05 PM 8/6/2017, Claudine Robbins wrote:

> SET VAR VCOUNT = 1

> SET VAR yylading TEXT = ('Vlad'+(CTXT(.VCOUNT)))vlad1 SET VAR 

>  TEXT = NULL-same as vlad1 = NULL SELECT LADING INTO 

>  INDICATOR ivlad FROM orders WHERE (dtg+split) = .ventry

> R>sho v vlad1

> LOAD FROM SEABOARD-CORPUS:

> [1] 5-1/8" X 15 MANUAL VALVE,

> BOLTS, RING GASKETS  ***

> LOAD FROM BASIC

> ENERGY-CORPUS:  [1] 5-1/8" X

> 15 MANUAL VALVE, BOLTS, RING

> GASKETS

> 

> I’m trying to do something which is NOT in the whitepaper dotted vs. 
> ampersand variables.

> 

> I’m in a 4 count while loop, so as vcount is incremented field vlad becomes 
> vlad1, vlad2, vlad3, and vlad4.

> 

> My select

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins

Oh, it helps a lot.  And what a beautiful thing it is when code works as 
expected!



One problem remains however, on the last field loaded I get an error 122 that 
LOADLADING needs to be TEXT.  Except for vamt which is currency, the variables 
and the temp table column are text so I’m stumped.  This is my code:



SET VAR vValue TEXT

SET VAR vValue = ('.VDTG'+(CTXT(.VCOUNT)))

SET VAR vValue = (.vValue + ',' + ('.Vcar'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vwb'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vamt'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vorigin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vdestin'+(CTXT(.VCOUNT))) )

SET VAR vValue = (.vValue + ',' + ('.Vlading' +(CTXT(.VCOUNT))) )

INSERT INTO comparecontrast 
(LOADDTGSPLIT,LOADCARNAME,LOADWB,CARAMT,LOADORIGIN,LOADDESTIN,LOADLADING) 
VALUES 



vValue = .VDTG1,.Vcar1,.Vwb1,.Vamt1,.Vo   TEXT

 rigin1,.Vdestin1,.Vlading1

Vlad1  = LOAD FROM SEABOARD-CORPUS:   TEXT

 [1] 5-1/8" X 15 MANUAL VALVE,

 BOLTS, RING GASKETS  ***





-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Sunday, August 06, 2017 10:39 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables



Razzak,

Well I can't wait to try it tomorrow!  I actually also have several values to 
load into my temp table...

Thank you very much.

Claudine

Sent from my iPhone



On Aug 6, 2017, at 8:23 PM, A. Razzak Memon 
> wrote:



Claudine,



The timing of your post couldn't have been better.



Yes, you can!



In your specific case ...



You will have to create an additional variable to build the string which is the 
"values" part of the insert.



When you finally go to use that variable, use the "&" prefix instead of the "." 
prefix.



Here is the key part of an example from one of my application ...



-- Predefined variables and logic is defined here ...

SET VAR vValue TEXT

WHILE vWorkingOn <> vLFNFileCount THEN

  SET VAR vWorkingOn = (.vWorkingOn + 1)

  SELECT (MAX(External_File_ID)+1) INTO vExternal_File_ID INDIC iv1 FROM 
External_Files

  -- Build the string with needed file names

  set var vValue = ('(' + '.vExternal_File_ID')

  set var vValue = (.vValue + ',' + '.vLFNFileNameS' + CTXT(.vWorkingOn))

  set var vValue = (.vValue + ',' + '.vLFNFileExt'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileDateTime'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFileSize'+(CTXT(.vWorkingOn)))

  set var vValue = (.vValue + ',' + '.vLFNFilePath'+(CTXT(.vWorkingOn)) + ')')

  -- Now use this string for the value part of the insert

  INSERT INTO External_Files +

  (External_File_ID, +

   External_File_Name, +

   External_File_Extension, +

   External_File_DateTime, +

   External_File_Size, +

   External_File_Original_Path) +

  VALUES +

   

ENDWHILE

RETURN



Hope that helps!



Very Best R:egards,



Razzak



At 09:05 PM 8/6/2017, Claudine Robbins wrote:



> SET VAR VCOUNT = 1

> SET VAR yylading TEXT = ('Vlad'+(CTXT(.VCOUNT)))vlad1 SET VAR

>  TEXT = NULL-same as vlad1 = NULL SELECT LADING INTO

>  INDICATOR ivlad FROM orders WHERE (dtg+split) = .ventry

> R>sho v vlad1

> LOAD FROM SEABOARD-CORPUS:

> [1] 5-1/8" X 15 MANUAL VALVE,

> BOLTS, RING GASKETS  ***

> LOAD FROM BASIC

> ENERGY-CORPUS:  [1] 5-1/8" X

> 15 MANUAL VALVE, BOLTS, RING

> GASKETS

>

> I’m trying to do something which is NOT in the whitepaper dotted vs. 
> ampersand variables.

>

> I’m in a 4 count while loop, so as vcount is incremented field vlad becomes 
> vlad1, vlad2, vlad3, and vlad4.

>

> My select correctly acquires the lading value.  Before I increment vcount = 
> (.vcount +1), I want to load vlad1 in a temporary table.

>

> INSERT INTO tempTBL VALUES ().  I’ve tried (),  
> (error), '',and '.yylading' .  All I manage to get is , 
> .yylading or vlad1 but not the actual value contained in vlad1.

>

> I don’t have any great hopes that this can be done but what the heck,

> I thought I’d ask anyway…









--

You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--

You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed

Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - SOLVED

2017-08-07 Thread karentellef via RBASE-L

I had 4 USB devices plugged in.  3 of the devices were turned OFF and one was 
ON when the update happened.   I lost the 3 devices that were OFF, only the ON 
device was still there after the update.

I was able to reinstall the 3 devices.  Not a good way for an update to behave!

Karen

 

 

 

-Original Message-
From: Albert Berry 
To: rbase-l 
Sent: Sun, Aug 6, 2017 5:41 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - 
SOLVED


Not the first time Windows 10 has removed printers. Happens to my wife’s PC 
about every 3rd update. Of course, I am anti-Microsoft biased since Win 10 
wiped the operating system off a laptop. 



On Aug 6, 2017, at 4:05 PM, karentellef via RBASE-L  
wrote:


And THANK YOU Dan.   I should've known that when there's an issue with reports, 
you just gotta check your printers!!!

Karen

 

 

 

-Original Message-
From: karentellef 
To: rbase-l 
Sent: Sun, Aug 6, 2017 5:00 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - 
SOLVED


My printer is gone!!   It's nowhere listed.

I'll reinstall that and look for the windows setting


Karen



 

 

 

-Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Sun, Aug 6, 2017 4:16 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports



Make sure u have a default printer set correct. Also I turn off the setting 
that allows windows to manage the default printer.



Dan Goldberg

Lance Camper






On Sun, Aug 6, 2017 at 1:15 PM -0700, "karentellef via 
RBASE-L" wrote:


This morning my laptop insisted on installing a really long Windows 10 update 
that I'd been putting off for probably a week.

This is on my personal development machine, not on a network.

And now my RBase reports are screwed up.  I can bring reports up in the 
designer, but both preview and printing from the R> prompt shows a blank page.  
Sometimes doing the preview locks RBase up.

Here's what I tested:

1.  I picked multiple local databases, they all behaved the same way.  All the 
databases are ones I use regularly, they all worked fine the last time I 
accessed before today.

2.  I would pick a table that has lots of data and multiple reports.  Some 
reports will print fine, some do not.  Cannot find a pattern.

3.  It happens on version 9.5, version X,  32-bit and 64-bit (I got them all 
installed here).  Fails on databases inALL versions

4.  My first hint that something was wrong:  I tried to do an insert into a 
table and got an error message I'd never seen, about not having privileges with 
owner password NONE.  None of my databases have an owner password.  I did an 
autochk and a reload of that database and the error message went away and I 
could insert.  However, it is one of the databases where reports do not work.


Anyone having this happening to them?  Can someone think of a Windows setting 
that would affect this?

Should I revert to the previous windows 10 build, and if so how do I do that?  
A restore point?

And then I guess I research how to stop windows 10 from updating..

Thank you Microsoft

Karen



-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.






-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.





-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Tip of the Day: LIST Computed, Autonumbered, and Default Value Columns

2017-08-07 Thread A. Razzak Memon


Monday, August 7, 2017

Tip of the Day: LIST Computed, Autonumbered, and Default Value Columns
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.2.20731 or higher
Section...: Commands
Keywords..: LIST, COMPUTED, AUTONUM, DEFAULT, Column Definition

Did you know the defined Computed, Autonumbered, and Default value columns can
be displayed for a connected database?

The LIST command has been enhanced with additional parameters to display a list
of Computed, Autonumbered, and Default value columns.

Syntax:

LIST COMPUTED
Displays the column name, table name, and attributes for each computed column

LIST AUTONUM
Displays the column name, table name, and attributes for each 
autonumbered column


LIST DEFAULT
Displays the column name, table name, and attributes for each column 
with a default

value definition

-- Examples:

CONNECT RRBYW19

R>LIST COMPUTED
   Computed Columns
   Name   Table  Attributes
   -- -- 


   FreightInvoiceHeader  Type: CURRENCY
 Expression: (NetAmount* .01)
   TaxInvoiceHeader  Type: CURRENCY
 Expression: (NetAmount* .081)
   InvoiceTotal   InvoiceHeader  Type: CURRENCY
 Expression: (NetAmount+Freight+Tax)
   Bonus  SalesBonus Type: CURRENCY
 Expression: (NetAmount*BonusPct)
   SalePrice  InvoiceDetail  Type: CURRENCY
 Expression: (Price- 
(Price*Discount/100))

   ExtPrice   InvoiceDetail  Type: CURRENCY
 Expression: (Units*SalePrice)
   EmpFullName2   Employee   Type: TEXT
 Expression: (EmpFName)
R>LIST AUTONUM
   Autonumber Columns
   Name   Table  Attributes
   -- -- 


   ContID ContactType: INTEGER
 Next Value: 1040.
 Increment by: 1.
   EmpTID Titles Type: INTEGER
 Next Value: 9.
 Increment by: 1.
   EmpID  Employee   Type: INTEGER
 Next Value: 116.
 Increment by: 1.
   CustID Customer   Type: INTEGER
 Next Value: 136.
 Increment by: 1.
R>LIST DEFAULT
   Columns with Defaults
   Name   Table  Attributes
   -- -- 


   WebAddress Employee   Type: TEXT
 Default Value: C:\

One of the most important aspects in business growth is your company 
data, and no
one else has more invested in your success than R:BASE Technologies. 
Invest forward

with R:BASE!

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--


--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - SOLVED

[RBASE-L] - Tip of the Day: LIST Computed, Autonumbered, and Default Value Columns

6 matches

Site Navigation

Mail list logo

Footer information