[Snowman12]

Hey,

Building a new dynamic robbery system in SQLite. I have a few errors with the db_get_field_assoc:

pawn Код:

db_get_field_assoc(Result,"Checkpoint",Field,sizeof(Field));
            RobberyInfo[i][pCheckpoint] = strval(Field);
            
            db_get_field_assoc(Result,"Label",Field,sizeof(Field));
            RobberyInfo[i][pLabel] = strval(Field); // line 90
            
            db_get_field_assoc(Result,"Created",Field,sizeof(Field));
            RobberyInfo[i][pCreated] = !!strval(Field);
            
            db_get_field_assoc(Result,"LocX",Field,sizeof(Field));
            RobberyInfo[i][pLocX] = floatstr(Field);
            
            db_get_field_assoc(Result,"LocY",Field,sizeof(Field));
            RobberyInfo[i][pLocY] = floatstr(Field);
            
            db_get_field_assoc(Result,"LocZ",Field,sizeof(Field));
            RobberyInfo[i][pLocZ] = floatstr(Field);
            
            db_get_field_assoc(Result,"RobberyValue",Field,sizeof(Field));
            RobberyInfo[i][pRobberyValue] = strval(Field);
            
            db_get_field_assoc(Result,"RobberyName",Field,sizeof(Field));
            RobberyInfo[i][pRobberyName] = strval(Field);
            
            db_get_field_assoc(Result,"Size",Field,sizeof(Field));
            RobberyInfo[i][pSize] = floatstr(Field); // 111
            
            db_get_field_assoc(Result,"Interior",Field,sizeof(Field));
            RobberyInfo[i][pInterior] = strval(Field);

[code]
C:\Users\Michael\Desktop\Los Santos Cops And Robbers 0.3c\pawno\include\robberysq.pwn(90) : warning 213: tag mismatch
C:\Users\Michael\Desktop\Los Santos Cops And Robbers 0.3c\pawno\include\robberysq.pwn(111) : warning 213: tag mismatch
C:\Users\Michael\Desktop\Los Santos Cops And Robbers 0.3c\pawno\include\robberysq.pwn(131) : warning 203: symbol is never used: "pRobTimer"
C:\Users\Michael\Desktop\Los Santos Cops And Robbers 0.3c\pawno\include\robberysq.pwn(131) : warning 203: symbol is never used: "pRobbingTicks"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


4 Warnings.
[/pawn]

Ignore the other 2 warnings.

[CmZxC]

Quote:

Originally Posted by a_sampdb.inc native db_get_field_assoc(DBResult:dbresult, const field[], result[], maxlength);

The Field must be a string, not a numeric value..

[Snowman12]

Incorrect Have you ever used SQLite? Well basically floatstr is equal to strval. and can be used as I use it fine inside my PlayerInfo DB.