RE: [RBASE-L] - How to drop a foreign key in a table using SQL

s where sys_table_name = ' .. ' SET VAR vIndexName = sys_index_name from sys_indexes where sys_table_id = .vTableID and sys_column_name = ' ' ALTER TABLE DROP CONSTRAINT Karen -Original Message----- From: Tony IJntema <t.ijnt...@cio-bv.nl> To: rbase-l <rbase-l@goog

RE: [RBASE-L] - How to drop a foreign key in a table using SQL

I am impressed and thank you for the work you have done. Yesterday I have asked an enhancement, which will take care of this situation, who knows Tony From: 'Lawrence Lustig' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: woensdag 28 september 2016 16:31 To:

RE: More Re: [RBASE-L] - Can't export any data

Have a look at the Help gateway export For a Workbook it should be: XLSW Tony From: 'Patti Jakusz' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: maandag 14 november 2016 15:19 To: rbase-l@googlegroups.com

RE: More Re: [RBASE-L] - Can't export any data

/01/16' OPTION COL_NAMES ON Thank you, though. Patti _ From: Tony IJntema <t.ijnt...@cio-bv.nl> To: rbase-l@googlegroups.com Sent: Monday, November 14, 2016 9:39 AM Subject: RE: More Re: [RBASE-L] - Can't export any data Have a look at the Help gateway export For a

RE: [RBASE-L] - Column size change

The manual way is the only way, unless you can unload all and perform a Search and replace. To be honest, unless it is a PK / FK I think it is better to create unique columnames. Tony From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of

RE: [RBASE-L] - Convert

Tom, If you want to be sure about the version of the database have a look at the command: PLUGIN GetDBVersion vResult|parameter It tells you about the version of the DB. Especially helpful in case of the same extension RX In your case not really necessary I think. Tony Van:

RE: [RBASE-L] - Tip of the Day: Error Tracking for Entry/Exit Procedures

Razzak, This feauture looks very nice. One question is left What do you mean by the phrase: the current output In other words where can I find the log file with this information Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens A.

RE: [RBASE-L] - strange error

Could it have something to do with permissions. If it still works fine on you C drive. Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Jim Belisle Verzonden: vrijdag 14 juli 2017 19:36 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - strange error We

RE: [RBASE-L] - Oddity when exporting a report to Excel

Do you have tried to align using one of these: The middle one Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Kayza Kleinman Verzonden: maandag 22 mei 2017 19:22 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Oddity when exporting a report to Excel I

SV: [RBASE-L] - Is there anybody out there?

ving explained that ... If the list server is quiet, it typically means that the latest public/private updates are working very well. I will post my "Tip of the Day" when the next public update with some cool features is officially released. Very Best R:egards, Razzak At 01:37 PM 1

RE: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software

Maybe you have to add file extensions of Rbase database to Bitdefender. In this case these files will not be checked for viruses Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens John Docherty Verzonden: maandag 29 januari 2018 10:38 Aan: RBASE-L Onderwerp:

RE: [RBASE-L] - Text file that retains trailing blank space

Personal I am using reports for this kind of functionality. There is an option Print to Text File and there you are able to create complex TXT files and so on. Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens James W. Kim, CPA, MBA

RE: [RBASE-L] - speed up when using date calculation (2)

Dan, Also worthwhile to know is that if you like to keep the variable in the temp view you have to surround the variable with brackets. In that case you will find the variable in the where clause otherwise the variable is being replaced by the calculated date. It looks like this: SELECT

RE: [RBASE-L] - speed up when using date calculation

Dan, FWIW create a temp view which is based upon this where clause Then you are able to perform a select without any condition Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Dan Goldberg Verzonden: dinsdag 27 februari 2018 0:49

RE: [RBASE-L] - Enhanced db grid - refresh filter

Dan, Have you considered to make use of the property ‘close’ and the property ‘open’ Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Dan Goldberg Verzonden: dinsdag 2 oktober 2018 19:03 Aan: rbase-l@googlegroups.com Onderwerp: RE: [RBASE-L] -

RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

Bruce, I have an application which imports several files of more than a million rows (size > 100 MB) and encounter no problems. My suggestion is to have a look into the file if there is a structure problem, like a missing quote or something else. You can start reading 600.000 rows and look

RE: [RBASE-L] - Version and Build in R:Compiler

Hi, Right Mouse click at the Executable; properties tab details Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Claudine Robbins Verzonden: vrijdag 28 december 2018 2:15 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Version and Build in R:Compiler

RE: [RBASE-L] - command history

Bill, Maybe it is an idea to check your permissions fort he concerning directory Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com Namens Bill Niehaus Verzonden: zondag 24 maart 2019 14:09 Aan: rbase-l@googlegroups.com Onderwerp: RE: [RBASE-L] - command history I stated my

RE: [RBASE-L] - Scrolling Regions

John, Take a look at the table relations in the form. I think the setting of Many to Many is the one you have to choose to achiev the result you want Tony Van: rbase-l@googlegroups.com Namens John Docherty Verzonden: maandag 25 maart 2019 13:16 Aan: RBASE-L Onderwerp:

RE: [RBASE-L] - Form version number

Doug, Have a look into system table SYS_FORMS3. There is a column SYS_FORM_VERSION This does not work in case the forms are part of the compiled app Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com Namens Doug Hamilton Verzonden: woensdag 22 mei 2019 20:31 Aan: R:Base

RE: [RBASE-L] - Read Only Form ?

Have a look at the table settings in the form. Tony Van: rbase-l@googlegroups.com Namens Mark Lindner Verzonden: donderdag 23 januari 2020 17:36 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Read Only Form ? I recently converted an old, complex 9.5 form to x5. For some reason

Re: [RBASE-L] - New Autochk Index command

Karen, Have a look at the Help AUTOCHK I believe it is all there what you are looking for Tony Op 12-3-2020 om 19:26 schreef 'Karen Tellef' via RBASE-L: I see a new AUTOCHK INDEX command in the March release. Question:  Is there a way to trap an error variable for it, so that the

Re: [RBASE-L] - eliminate weekends

James, Two possible solutions: 1. by using Switch / Endsw command   SET VAR V_CURRENT_DAY = (IDWK(.#DATE))   SWITCH (.V_CURRENT_DAY)     CASE 1   SET VAR V_WORKINGDAY_7 = (.#DATE + 9)   BREAK ...     CASE 5   SET VAR V_WORKINGDAY_7 = (.#DATE + 11)   BREAK   ...  

Re: [RBASE-L] - Table-Bound Forms: Linked-Table Limit?

I have a form with 1 master table and 17 slave tables (1 to many) it works fine for years now Tony 0570 525390 Op 2-9-2020 om 23:17 schreef Bruce Chitiea: All: I suppose I'm testing how far the "Custom Table Relationship" capability can be pushed in Forms design. I'm thinking of a tabbed

Re: [RBASE-L] - Can't figure out an update command

Patti, To start with,  it is probably not an good idea to store a result in a seperate column, because it represents only the current situation. You also can create a view which always  will reflect the actual situation. However if you still want to update a column in a table, here a is

Re: [RBASE-L] - Enhanced Variable calendar

Karen, You can make today invisible Change Todays Date frame for instance to White then Today is not highlighted  anymore Tony Op 29-8-2020 om 19:47 schreef 'Karen Tellef' via RBASE-L: They are two different variables, and they are initialized to null when the form comes up Karen

Re: [RBASE-L] - Enhanced Variable calendar

as the default blue, but it still looks like a date has been selected in both calendars. Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Sun, Aug 30, 2020 11:50 am Subject: Re: [RBASE-L] - Enhanced Variable calendar Karen, I have tried this using S

Re: [RBASE-L] - Enhanced Variable calendar

highlight. Thinking that I might submit an enhancement request to highlight NO date Karen -Original Message----- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Sat, Aug 29, 2020 4:01 pm Subject: Re: [RBASE-L] - Enhanced Variable calendar Karen, You can make today invisible Change T

Re: [RBASE-L] - PDF form generation problems

Patti, It looks like the fields have the fieldsame name. For instance if a field has the name: Cliuentname and you fill it with the name Smith als the fields with the fieldname Clientname will be filled with Smith Tony Op 25-10-2020 om 00:41 schreef 'Patti Jakusz' via RBASE-L: No, it is

Re: [RBASE-L] - PDF form generation problems

: There is only one PDF text field per row in the table.  How would I give it a different name for each row in the table? On Sunday, October 25, 2020, 3:02:25 AM EDT, Tony IJntema wrote: Patti, It looks like the fields have the fieldsame name. For instance if a field has the name: Cliuentname and you

Re: [RBASE-L] - Best practices?

Karen, A beautiful example of Murphy's law, I think. The "easy" thing which I would choose is option 3. However, there is another option, which I use in my apps. In every app, which I develop, I have a central program, called something like temptableview.rmd. In this program I create all

Re: [RBASE-L] - Sub Reports and Break Headers

Bruce, At least in version 10.5 the reports have the same functionality as the forms. You can establish your own relationships. So it is not longer needed to avoid common column names Tony Op 25-6-2020 om 01:42 schreef Bruce Chitiea: Thank you, Jim. Reducing common columns to a sole

Re: [RBASE-L] - Boolean

Not a nice solution but open the CFG file with  f.or instance Notepad or Rbedt and remove the line with Boolean. Then save the file and use this CFG file for your complied application. It works fine for the moment (at least I have not encountered any problem anymore). Report this bug also

Re: [RBASE-L] - Report output to Excel

Karen, You can do it this way: Select all figures you like to convert (the green marker up left is showing that the number is stored as text) Select the exclamation mark and then a right mouse click You should see the menu as below (sorry in Dutch) The second option is convert to number.

Re: [RBASE-L] - Report output to Excel

my sum below: If I type a "2" over one of those 1s, the sum shows 2: Karen -Original Message----- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:15 am Subject: Re: [RBASE-L] - Report output to Excel Karen, You can do it this way: Select all figure

Re: [RBASE-L] - autonum when creating

AUTONUM IN   USING   NUM Tony Op 24-12-2020 om 14:27 schreef 'Jim Belisle' via RBASE-L: What is the proper syntax for creating a column within a temp table as an auto numbered column? James Belisle *Making Information Systems People Friendly Since 1990* -- For group guidelines, visit

Re: [RBASE-L] - autonum when creating

* *From:*rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com>> *On Behalf Of *Tony IJntema *Sent:* Thursday, December 24, 2020 7:41 AM *To:* rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> *Subject:* Re: [

Re: [RBASE-L] - autonum when creating

change in the future, I don't have to crawl through all the code looking for the table definitions. The projected temp table structure will always be current. Enjoy the sunshine. Doug On 12/24/2020 9:28 AM, Tony IJntema wrote: James, Sorry for not replying. However the sun was shining after

Re: [RBASE-L] - Re: SQL book

Talking about history. At the time of R:Base 4000 Microsoft did not have its own DBMS and they advised more or less R:base 4000. In the early 80's Bill Gates once visited us in Deventer, Holland and advised to use R:Base 4000 From that moment on I have been using R:Base Tony Op

Re: [RBASE-L] - Report output to Excel - FOUND IT!

ng. Here's my sum below: If I type a "2" over one of those 1s, the sum shows 2: Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Tue, Dec 29, 2020 9:15 am Subject: Re: [RBASE-L] - Report output to Excel Karen, You can do it this way: Select all figures

Re: [RBASE-L] - Labels

Rich, have a look at label templates Tony Op 25-05-2021 om 20:32 schreef Rich: Avery 5160? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To

Re: [RBASE-L] - change date to datetime

Dan, Try this: Create a new column like  date_time_field DATETIME in the table Then perform the next statement (where datefield is the original date column) UPDATE Testdate SET date_time_field  = (DATETIME(datefield,00:00)) Tony Op 21-05-2021 om 19:18 schreef Dan Goldberg: I am trying

Re: [RBASE-L] - Suggestions on Using AutoCHK in a Command File

Paul, I have implemented more or less the same procedure as Karen describes with a few differences. The differences are: On beforehand I perform some calculations like counting the number of columns in all tables and the total number of rows in the database It looks like this:   SET VAR

Re: [RBASE-L] - edit table using aliases

Jim, Spaces are not allowed. Suggestion: Use the underscore: Model_Number Tony Op 03-03-2021 om 19:13 schreef 'Jim Belisle' via RBASE-L: I am using the syntax given in the help in an attempt to edit a table using alias column names. This is the syntax I am using. EDIT + model# AS `Model

Re: [RBASE-L] - Moving variables between reports

Javier, Unless I misunderstand the problem, you can copy and paste using the icons on your screen in the reportwriter. Tony Op 20-09-2021 om 11:27 schreef javier.valen...@vtgonline.com: I have a report that uses a large number of report defined variable to calculate totals,

Re: [RBASE-L] - Exporting to Excel

Jim, It looks as a bug in Office365. However you probably can avoid this error using the option 'Without using Excel' The advantage of this option is that the availabilty of Excel is not needed anymore and it is also very fast. Tony Op 11-11-2021 om 05:14 schreef 'Jim Belisle' via

Re: [RBASE-L] - Capture a file Name possible

If the filename does not have always the same length, you can use a procedure like this   -- capture the file name using procedure of Tony Luck   SET VAR vfile  = 'PAYMENTS_637467300105556434-20210120-030011.csv'   -- (SLOCP(TextNoteVarcharValue,string,occurrence))   -- assuming '-' is always

Re: [RBASE-L] - Extraction de données / Data Extraction

Bonjour Jean-Marc, La fonction que vous pouvez utiliser est SGET Je pense que le code postal est toujours à 5 chiffres en France Mais le toponyme en France contient souvent un ou plusieurs espaces Donc, ce que vous pouvez faire, c'est d'abord rechercher le code postal dans la chaîne, en

Re: [RBASE-L] - detect wireless connection

Dan, You can use the gateway command, like: GATEWAY IMPORT CSV WIFI.TXT REPLACE WIFI_table Tony Op 22-04-2022 om 19:59 schreef Dan Goldberg: So my first hurdle is to find a way to put the contents of a txt file into a variable. Does anyone know how to do that? I am drawing a blank. TIA

Re: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes

Hi, Though it is maybe not the expected answer to your question, it could be a solution for your problem. What you can do is create the temp table once and then only delete all the rows when you start the procedure. Tony Op 27-05-2023 om 05:35 schreef Doug Hamilton: I create a temporary

Re: [RBASE-L] - creating text file with blank spaces in tact

Hello James, Maybe it is an idea to have a look at the report possibilities. Print a report as a txt file is possible and there are a lot of options available. open the report designer and choose for File | Print to Text File Setup There you are able to create a TXT file in the way you

Re: [RBASE-L] - Storing PDF in blob field

Hi, See Help LOAD, example 7 LOAD ImageTable 1,['image.bmp'] END the same applies to PDF-files Tony Op 10-03-2024 om 17:02 schreef rkco...@gmail.com: I need some help with storing a PDF file in a Varbit (blob) field. Thanks. -- For group guidelines, visit