Query limitation

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Query limitation

Doug Hall-6
In Active4D v4.5 (which I'm *almost* done with!!!!), there was an alpha
field limitation of forty characters. I can't find the reference, but I
believe it was actually a limitation of 4D 2004. This is no longer factor
with 4Dv15 and Active4D 7+ is it? I have an email field that I was limiting
to 40 characters because of this old limitation, that I should probably
lengthen.

While I'm at it, what length do you have for your email fields? I know they
*can* be 254 characters, but that's a bit much, right?

Thanks,
Doug
_______________________________________________
Active4D-dev mailing list
[hidden email]
http://list.aparajitaworld.com/listinfo/active4d-dev
Archives: http://active4d-nabble.aparajitaworld.com/
Reply | Threaded
Open this post in threaded view
|

Re: Query limitation

Aparajita Fishman
Active4D itself has no limitation on field length. Internally it uses the equivalent of C_TEXT for alpha fields.

All the best,

  - Aparajita

> On Feb 20, 2018, at 12:48 PM, Doug Hall <[hidden email]> wrote:
>
> In Active4D v4.5 (which I'm *almost* done with!!!!), there was an alpha
> field limitation of forty characters. I can't find the reference, but I
> believe it was actually a limitation of 4D 2004. This is no longer factor
> with 4Dv15 and Active4D 7+ is it? I have an email field that I was limiting
> to 40 characters because of this old limitation, that I should probably
> lengthen.
>
> While I'm at it, what length do you have for your email fields? I know they
> *can* be 254 characters, but that's a bit much, right?
>
> Thanks,
> Doug
> _______________________________________________
> Active4D-dev mailing list
> [hidden email]
> http://list.aparajitaworld.com/listinfo/active4d-dev
> Archives: http://active4d-nabble.aparajitaworld.com/

_______________________________________________
Active4D-dev mailing list
[hidden email]
http://list.aparajitaworld.com/listinfo/active4d-dev
Archives: http://active4d-nabble.aparajitaworld.com/
Reply | Threaded
Open this post in threaded view
|

Re: Query limitation

Norbert Pfaff-2
When I have written querys, there was a problem for searching strings longer as 40 characters.

I think it was a problem of the 4D external mechanism. Some times I searched for streets wich existed, but I didnt find.

My solution was to write a wrapper for the query command.

queryLongNames(->[einheit];->[einheit]name;$strasse)

  // ----------------------------------------------------
  // User name (OS): npfaff
  // Date and time: 28.12.10, 09:19:07
  // ----------------------------------------------------
  // Method: QueryLongNames
  // Description
  // Wrapper für Bug in External API (Suche nach Strings über 40 Zeichen funktionieren in Externals nicht)
  //
  // Parameters
  // ----------------------------------------------------
C_POINTER($1;$2)
C_TEXT($3)
QUERY($1->;$2->;=;$3)




> Am 20.02.2018 um 22:20 schrieb Aparajita Fishman <[hidden email]>:
>
> Active4D itself has no limitation on field length. Internally it uses the equivalent of C_TEXT for alpha fields.
>
> All the best,
>
>  - Aparajita
>
>> On Feb 20, 2018, at 12:48 PM, Doug Hall <[hidden email]> wrote:
>>
>> In Active4D v4.5 (which I'm *almost* done with!!!!), there was an alpha
>> field limitation of forty characters. I can't find the reference, but I
>> believe it was actually a limitation of 4D 2004. This is no longer factor
>> with 4Dv15 and Active4D 7+ is it? I have an email field that I was limiting
>> to 40 characters because of this old limitation, that I should probably
>> lengthen.
>>
>> While I'm at it, what length do you have for your email fields? I know they
>> *can* be 254 characters, but that's a bit much, right?
>>
>> Thanks,
>> Doug
>> _______________________________________________
>> Active4D-dev mailing list
>> [hidden email]
>> http://list.aparajitaworld.com/listinfo/active4d-dev
>> Archives: http://active4d-nabble.aparajitaworld.com/
>
> _______________________________________________
> Active4D-dev mailing list
> [hidden email]
> http://list.aparajitaworld.com/listinfo/active4d-dev
> Archives: http://active4d-nabble.aparajitaworld.com/

Norbert Pfaff
Hammelstalstr. 52
67098 Bad Dürkheim

Fon: 06322 9108028
Skype:    npfaff
eMail: [hidden email]



_______________________________________________
Active4D-dev mailing list
[hidden email]
http://list.aparajitaworld.com/listinfo/active4d-dev
Archives: http://active4d-nabble.aparajitaworld.com/
Reply | Threaded
Open this post in threaded view
|

Re: Query limitation

Aparajita Fishman
That 40 character limitation hasn’t been there since Active4D v5 came out, which was 9 years ago.

All the best,

  - Aparajita

> On Feb 21, 2018, at 12:08 AM, Norbert Pfaff <[hidden email]> wrote:
>
> When I have written querys, there was a problem for searching strings longer as 40 characters.
>
> I think it was a problem of the 4D external mechanism. Some times I searched for streets wich existed, but I didnt find.
>
> My solution was to write a wrapper for the query command.
>
> queryLongNames(->[einheit];->[einheit]name;$strasse)
>
>  // ----------------------------------------------------
>  // User name (OS): npfaff
>  // Date and time: 28.12.10, 09:19:07
>  // ----------------------------------------------------
>  // Method: QueryLongNames
>  // Description
>  // Wrapper für Bug in External API (Suche nach Strings über 40 Zeichen funktionieren in Externals nicht)
>  //
>  // Parameters
>  // ----------------------------------------------------
> C_POINTER($1;$2)
> C_TEXT($3)
> QUERY($1->;$2->;=;$3)
>
>
>
>
>> Am 20.02.2018 um 22:20 schrieb Aparajita Fishman <[hidden email]>:
>>
>> Active4D itself has no limitation on field length. Internally it uses the equivalent of C_TEXT for alpha fields.
>>
>> All the best,
>>
>> - Aparajita
>>
>>> On Feb 20, 2018, at 12:48 PM, Doug Hall <[hidden email]> wrote:
>>>
>>> In Active4D v4.5 (which I'm *almost* done with!!!!), there was an alpha
>>> field limitation of forty characters. I can't find the reference, but I
>>> believe it was actually a limitation of 4D 2004. This is no longer factor
>>> with 4Dv15 and Active4D 7+ is it? I have an email field that I was limiting
>>> to 40 characters because of this old limitation, that I should probably
>>> lengthen.
>>>
>>> While I'm at it, what length do you have for your email fields? I know they
>>> *can* be 254 characters, but that's a bit much, right?
>>>
>>> Thanks,
>>> Doug
>>> _______________________________________________
>>> Active4D-dev mailing list
>>> [hidden email]
>>> http://list.aparajitaworld.com/listinfo/active4d-dev
>>> Archives: http://active4d-nabble.aparajitaworld.com/
>>
>> _______________________________________________
>> Active4D-dev mailing list
>> [hidden email]
>> http://list.aparajitaworld.com/listinfo/active4d-dev
>> Archives: http://active4d-nabble.aparajitaworld.com/
>
> Norbert Pfaff
> Hammelstalstr. 52
> 67098 Bad Dürkheim
>
> Fon: 06322 9108028
> Skype:    npfaff
> eMail: [hidden email]
>
>
>
> _______________________________________________
> Active4D-dev mailing list
> [hidden email]
> http://list.aparajitaworld.com/listinfo/active4d-dev
> Archives: http://active4d-nabble.aparajitaworld.com/

_______________________________________________
Active4D-dev mailing list
[hidden email]
http://list.aparajitaworld.com/listinfo/active4d-dev
Archives: http://active4d-nabble.aparajitaworld.com/