[Gambas-user] gb.db Unknown symbol 'Fields' in class 'Connection'

[paulwheeler]

The correct one is:
htable.Fields 

I assume you have this line in your code:
Dim hTable As Table

Your code is similar to mine, but I do not use the "with".

I do the full line. hTable.Fields.Add("cod_ficha", db.String, 20)
Try doing it that way.

Maybe there is a bug in the "With"???



paul

On 11/30/2013 02:44 PM, PICCORO McKAY Lenz wrote:
> and then i have this error when run in another runtime environment:
> 
> Unknown symbol 'Fields' in class 'Connection'
> 
> i have this code:
> 
> If Not consq.Tables.Exist("sysasis_listado") Then
>                 hTable = consq.Tables.Add("sysasis_listado")
>                 With hTable.Fields
>                     .Add("cod_ficha", db.String, 20)   ' FICHA/Cedu, el id
> del trabajador en VNZ es numero de la CI
>                     .Add("cod_lugar", db.String, 20, lugar)   ' nombre de
> ubicacion(tienda o sobrenombre) en al que
>                     .Add("fec_actualizacion", db.Date,, Now)   ' fecha del
> registro de dia de su huella dactilar
>                     .Add("cod_usuasys", db.String, 20)   ' ficha / cedula /
> id del trabajador NOTA ESTE NO ES CI, en VNZ es CI
>                 End With
>                 hTable.PrimaryKey = ["cod_ficha", "cod_lugar"]
>                 hTable.Update
>                 If Error Then
>                     Print "Error - new db remote: " & Error.Code & " " &
> Error.Text
>                 Else
>                     Print "Advertencia - new db remote: created " &
> Error.Code & " " & Error.Text
>                 Endif
>             Else
>                 Print "Advertencia - new db remote: existe: " & Error.Code
> & " " & Error.Text
>             Endif
> 
> What its the correct? htable.Field or htable.Fields ? please urgency
> 
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT 
> organizations don't have a clear picture of how application performance 
> affects their revenue. With AppDynamics, you get 100% visibility into your 
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>