Re: [GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-13 Thread josep porres
thanks Craig your assumption is right. I have a given table structure, so redesign it now is not possible due to having change a lot of things Furthermore, using M3TRAM INTEGER[5], PREU NUMERIC(10,2)[5] seems to me a very good way but I think it may appear problems when accessing to

Re: [GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-13 Thread Craig Ringer
josep porres wrote: I have a given table structure, so redesign it now is not possible due to having change a lot of things Furthermore, using M3TRAM INTEGER[5], PREU NUMERIC(10,2)[5] seems to me a very good way but I think it may appear problems when accessing to that table from third

[GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-12 Thread josep porres
Hi everyone, I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp) that code is Const f2_MAX_TRAMS = 5 Dim f2_rTarifaA as new ADODB.Recordset Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa Dim i As Integer, j

[GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-12 Thread josep porres
Hi everyone, I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp) that code is Const f2_MAX_TRAMS = 5 Dim f2_rTarifaA as new ADODB.Recordset Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa Dim i As Integer, j

[GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-12 Thread josep porres
Hi everyone, I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp) that code is Const f2_MAX_TRAMS = 5 Dim f2_rTarifaA as new ADODB.Recordset Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa Dim i As Integer, j

Re: [GENERAL] porting vb6 code to pgplsql, referencing fields

2008-03-12 Thread Craig Ringer
josep porres wrote: but the most important is how can I reference the fields inside de loop By the fields I assume you mean the fields with names that end in a number from 1 to 5, and you want to access those fields in a loop as if you were indexing an array? I think you might want to