Checked :)
Em 07/04/2016 13:33, Z T Minhas ztmin...@yahoo.com [firebird-support]
escreveu:
Just checking
--
Atenciosamente,
Hugo Eyng
Just checking
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 m...@lawinegevaar.nl
[firebird-support] firebird-support@yahoogroups.com wrote:
On 25-4-2015 08:08, 'Walter R. Ojeda Valiente'
On 25-4-2015 08:08, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
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 signs, inverse conditions, etc.
Thanks to everyone for all the feedback.
if (param IS SIMILAR '[0-9]+') then
Did everything I needed it to do.
Thanks again.
On Thu, 23 Apr 2015 20:00:32 -0400, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]
firebird-support@yahoogroups.com wrote:
You can use SIMILAR TO, something like it:
SELECT
MyColumn1,
MyColumn2,,
MyColumn3
FROM
MyTable
WHERE
MyColumn1
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
value and it would be nice to be able to know if CAST(param as BIGINT) is going
to fail before an exception is thrown.
You can use SIMILAR TO, something like it:
SELECT
MyColumn1,
MyColumn2,,
MyColumn3
FROM
MyTable
WHERE
MyColumn1 SIMILAR TO '[[:DIGIT:]]*'
Where just the digits 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 are valid.
If you need the decimal point too, try something like it, where the
decimail
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
sistemas2000profesio...@gmail.com wrote:
You can use SIMILAR TO, something like it:
SELECT
MyColumn1,
MyColumn2,,
MyColumn3
FROM
MyTable
Again, if you can read Spanish then the following article has more examples:
https://firebird21.wordpress.com/2015/04/23/validando-que-el-contenido-de-un-char-o-varchar-sea-numerico/
Greetings.
Walter.
On Thu, Apr 23, 2015 at 8:03 PM, Walter R. Ojeda Valiente
Hi
I want to install FB 3.0 alpha2 in Linux debian 7.3, that the tools of
administration recommend me to try the new characteristics owed.
Best Regards
| ISMAEL |
On 09/01/2014 21:39, Ismael L. Donis Garcia wrote:
Test.
I am not receiving the messages that I send to the list
That seems to be how the list works. Weird, innit.
--
Tim Ward
Test.
I am not receiving the messages that I send to the list
Best Regards
| ISMAEL |
13 matches
Mail list logo