Further Market
  • Essentials

    • Foreword
    • What is FM Script ?
    • The philosophy and benefits of FmScript
    • What you will learn
  • Recall

    • Internet: who? what? What is that?
    • Further market and FMScript
    • The compiler
  • Download
  • Getting started

    • Installation
    • Create a business account
    • Connect to the PC application
    • Create your first applet
    • Create your first web applet
    • Compiler view
  • Basics

    • basic rules
    • Reserved keywords
    • The Syntax
    • Coding Style
    • comments
    • Variables, constants, and data types
    • Convertion of types
    • Conditions and loops
  • Functions

    • Create a Menu
    • Create input field (Input2)
    • Create a QR Code
    • Scan a QR Code
    • Strings functions
    • Array functions
    • Date Time functions
    • Mathematics functions
    • JSON functions
    • XML functions
    • Call Http request
    • Manipulate Sessions
    • Financial functions
    • Notifications
    • Bleutooth Printer
  • Demos

    • Advanced Inputs
    • Call http Request
    • loops and conditions
    • Menu inputs
    • Array items count
    • Simpe for
    • simple select count Sql Query
    • Date and Time picker form
    • Get credit balance
    • is valid city
    • user info from phone number
    • get country and city from form
    • simple ussd link switch
    • charge user credit
    • simple message box
    • user entry code
    • get users relations
    • my external payements collected
    • call google Map
    • in App direct publish
    • Geo location
    • Charts
    • menu with hints
    • call system Messenger
    • user start code
    • In call Gallery
    • credit card payment Request
    • MTN CMR Airtime Product Subscription
    • MenuItemAddContacts
    • AJax and FM Input
    • Input2
    • MenuItemAddRichMedias
    • MenuItemAddTagsItems2
    • BlinBlin Menu + javascript
    • GENERAL ALERT MESSAGE WITH JSON OPTIONS
    • Barcode
  • databases

    • CRM
    • External Payments
    • Bills
    • Sales
    • Games
    • Applets
    • Payments Gateway
    • Manipulate Select Queries
  • APIs

    • Further Markey Pay button integration
    • Mobile Money cash collector
    • Bill Api
    • API PUBLISH PRODUCT
    • Sale Api
    • SMS Api
  • Advanced

    • Actions scheduler
    • Events settings
  • USSD CAMEROON

Manipluate Queries

  • Query_FieldName
  • Query_FieldsCount
  • Query_RecordsCount
  • Query_FieldValue
  • Query_FieldValue_Locate
  • Query_First
  • Query_Next
  • Query_Last
  • Query_Prior
  • Full Demo


the SQL selection functions exposed on the compiler return result objects which with the specific functions can be extracted and exploited. We will now show some of them.

Query_FieldName

Each select Query has the param QueryName. this function return FieldName

Signature
                
Query_FieldName(QueryName : String, FieldIndex : Integer);
                
            

 

Query_FieldsCount

Return Fields Count(Integer Value)

Signature
                
Query_FieldsCount(QueryName : String);
                
            


 

Query_RecordsCount

Return Query Records Count (Integer Value)

Signature
                
Query_RecordsCount(QueryName : String);
                
            

 

Query_FieldValue

Return Query Field Value

Signature
                
Query_FieldValue(QueryName : String, FieldName : String);
                
            

 

Query_FieldValue_Locate

This function allows you to retrieve an entry corresponding to a specific value of a specific field! It return 1,XXX if one entry have been found or 0,XXX if not.

Signature
                
Query_FieldValue_Locate(QueryName, FieldName, FieldValue : String);   
                
            

 

Query_First

Move active record to 1st. Return active Record Number

Signature
                
Query_First(QueryName : String);
                
            

 

Query_Next

Move active record to next. Return active Record Number

Signature
                
Query_Next(QueryName : String);
                
            

 

Query_Last

Move active record to last. Return active Record Number

Signature
                
Query_Last(QueryName : String);
                
            

 

Query_Prior

Move active record to 1st. Return active Record Number


Signature

                
Query_Prior(QueryName : String);
                
            

 

Full Demo

The following example illustrates a data extraction from a CRM.

Signature
                
VAR Result  : String;
VAR Result2 : String;
VAR FileID  : String;
VAR ValueStr: String;
VAR Count,i : Integer;


ArrayInsertValue('Authorised', 0, '677440031');
ArrayInsertValue('Authorised', 1, '675840531');
ArrayInsertValue('Authorised', 2, '1234567890');

IF ArrayIndexOf('Authorised', USER_PhoneNumber ) <> '-1' THEN
(
  FileID  := '8';
  Result  := CRM_Select('Query1',FileID, '*','', '',1);
  Count   := Query_RecordsCount('Query1');

  Result := MenuItemAdd('MyMenu','Select', '', '', '', '', '', '', '', '');

  Query_First('Query1');
  FOR i:=0 TO PRED(Count) DO
  (
    ValueStr := Query_FieldValue('Query1', 'Name');
    Result   := MenuItemAdd('MyMenu',IntToStr(i+1)+'. '+ValueStr, ValueStr, IntToStr(i+1) , '', '', '', '', '', '', '');
	
	Query_Next('Query1');
  );

  Result := InputMenu('MyMenu', 60000, '', '');
  Exit;
)
ELSE
(
 Result := 'Unauthorized ACCESS ' +  USER_Name;
 Exit;
);
                
            


Payments Gateway
Api Pay button integration


Our Partners

Support
      Telephone : (+237) 675979899 / 676009100
      Email : fm_support@f-m.fm
      P.O Box : 774 BAFOUSSAM
Available On

no
no

Further Market Inc
Copyright © 2012-2021.