FiveTech Software tech support forums

... indexes on the server and started creating
in local system.
[/quote]


Do you also happen to have any speed tests?


Yes. I made several time comparisons to create new indexes or adding
additional tags in server Vs creating indexes every time in local system.

My results were always moved me to ...

Hello Otto
I don't want to get into the discussion of whether DBF or SQL is better as the gap is so wide that no comparisons can be made.
I can say that my small company would be dead now if I hadn't started using SQL 10 years ago.

Demonstrating the advantage of using an SQL database over DBF ...

... next

AP_SetContentType( "application/json" )

?? hb_jsonEncode( aRows )

retu nil

I will set up some metrics for you to make comparisons between different systems, but to be as realistic as possible, we would have to do it on the same computer, whatever it may be. I'm telling you ...

Thank you, Enrico, I just think it's important that as an HTML and JavaScript programmer
one makes comparisons, to understand what one is doing. Particularly,
I believe that EVENTHANDLERS are more universal, and in Fivewin,
by extensively using ::Super:, the possibilities in screen design can ...

... is +ve and desc if -ve.
If any element of the array is codeblock, the comarison is made
{ |x,y| Eval( b,x ) < Eval( b, y ) }
All string comparisons are case insensitive and values of
different datatypes are sorted on the type.

* New: function FW_GetClipboardData( [[@]Format] ) --> uData ...

PADR is not at all necessary.

Can try:
? ASort( { "CDX", "c", "Cpp", "cH" },,,;
{ |x,y| LOWER( X ) < LOWER( y ) } )


For case insensitive comparisons, we recommend using

FW_Stricmp( c1, c2 ) // --> -2, -1, 0, 1, 2


Incidentally, this function Data Type safe also.

The above function can be ...

... TextTo" == "" )
This does not require changing SET EXACT.
Please note that setting SET EXACT ON will have global effect and somewhere some comparisons may give different results.

Dear Rao
Do you mean that what we have to do is induce our code to obtain the result that we expect and that it is ...

Use
? !( "TextTo" == "" )
This does not require changing SET EXACT.
Please note that setting SET EXACT ON will have global effect and somewhere some comparisons may give different results.

... sample on small or medium-sized tables demonstrating this?

Especially for web pages, DBF files are easy to use.
Do you have experience with it? Comparisons? Demands on the server, server maintenance, flexibility when moving.

Security, since only a few people in the relationship use DBF files, they ...

... friends here who just wait with their mod harbour start, it would be good if you could make some advantages
of the WYSIWYGbuilder and possibly comparisons with other editors ( Wordpress, WIX, bootstrap, jimdo, mdbootstrap, etc.).

How exactly does WYSIWYGbuilders support you?

Is that a two-way ...

... to be cumbersome connecting with different databases. I am not saying that it is not possible to connect to different databases and prepare comparisons. If the count of the number of company's increase in the future this is going to make things much harder for you.

If you keep a separate ...

... to be cumbersome connecting with different databases. I am not saying that it is not possible to connect to different databases and prepare comparisons. If the count of the number of company's increase in the future this is going to make things much harder for you.

If you keep a separate ...

Hi Antonino
Database is BD2 on iSeries IBM and field CODICE is CHAR(15) (not VARCHAR) but when recordset read table chars are trimmed:
Field CHAR(15) in DBU = "123456abc "
field read = "123456abc".

which database are you using? the column is char(15) or varchar(15)?
On our application on SQL Server we have all column "char" and the spaces are not trimmed.
they are trimmed with varchar

hi Marc, thank you, that's good solution.
But is SET EXACT ON a good solution too?

why CHAR fields in recordest lose right blanks ?