Loading ...
Sorry, an error occurred while loading the content.

Messages List

126658

Re: How to trigger "Connection shutdown" error.

Here I've found the same question but still without answer: IBPP, a C++ API for Firebird Server / Mailing Lists
un_spoken
2:49 AM
#126658
 
126657

Re: Test VARCAHR for numeric

Thanks to everyone for all the feedback. if (param IS SIMILAR '[0-9]+') then .... Did everything I needed it to do. Thanks again.
sboydlns
Apr 25
#126657
 
126656

Re: Test VARCAHR for numeric

Very interesting Mark, I shall remember that for the time when Firebird3 is coming here. Greetings. Walter. On Sat, Apr 25, 2015 at 3:14 AM, Mark Rotteveel
Walter R. Ojeda Valiente
Apr 25
#126656
 
126655

Re: Test VARCAHR for numeric

On 25-4-2015 08:08, 'Walter R. Ojeda Valiente' ... With Firebird 3 functions you can define a function isvalidint: CREATE FUNCTION isvalidint(stringValue
Mark Rotteveel
Apr 25
#126655
 
126654

Re: Test VARCAHR for numeric

Hello Mark This article: https://firebird21.wordpress.com/2015/04/23/validando-que-el-contenido-de-un-char-o-varchar-sea-numerico/ Also has examples con minus
Walter R. Ojeda Valiente
Apr 24
#126654
 
126653

How to trigger "Connection shutdown" error.

Hello, My application is handling different kinds of connection errors: 335544721 network_error Unable to complete network request to host "@1". 335544722
un_spoken
Apr 24
#126653
 
126652

Re: SQLAnywhere to Firebird possibility

... Your particular example I would typically write (using Fb 2.5, but I think it has been available since 2.0 or 2.1): With tmp(MYDIV) as (SELECT (x/y) from
Svein Erling Tysvær
Apr 24
#126652
 
126651

Re: Test VARCAHR for numeric

On Thu, 23 Apr 2015 20:00:32 -0400, "'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support]" ... I'd also check for minus signs, and
Mark Rotteveel
Apr 23
#126651
 
126650

specific output from ISQL

Hi everyone. I am cloning a DB using a recipe found at: http://www.firebirdsql.org/file/documentation/reference_manuals/user_man
Andrew Zenz
Apr 23
#126650
 
126649

Re: Test VARCAHR for numeric

Again, if you can read Spanish then the following article has more examples:
Walter R. Ojeda Valiente
Apr 23
#126649
 
126648

Re: Test VARCAHR for numeric

Sorry, typo in the SELECT, just one comma after MyColumn2. Greetings. Walter. On Thu, Apr 23, 2015 at 8:00 PM, Walter R. Ojeda Valiente
Walter R. Ojeda Valiente
Apr 23
#126648
 
126647

Re: Test VARCAHR for numeric

You can use SIMILAR TO, something like it: SELECT MyColumn1, MyColumn2,, MyColumn3 FROM MyTable WHERE MyColumn1 SIMILAR TO '[[:DIGIT:]]*' Where just the digits
Walter R. Ojeda Valiente
Apr 23
#126647
 
126646

SQLAnywhere to Firebird possibility

Hi, I have been a major contributor to Firebird since 2003, also my previous company "BASX", which I was the Head developer of, was a gold sponsor of Firebird.
sir_wally_lewis
Apr 23
#126646
 
126645

Test VARCAHR for numeric

Is there any way, within a stored procedure, to test a VARCHAR to see if it contains a valid number? I have a parameter that can contain different types of
sboydlns
Apr 23
#126645
 
126644

Re: How To Change Column DataType From Varchar To Integer ?

... Changing the values to null does not change the data type of the column. There is no "quick and dirty" way to do this change. First, test the old column
Helen Borrie
Apr 22
#126644
 
View First Topic Go to View Last Topic
Loading 1 - 15 of total 126,658 messages