only 50 flowfields in dataport?

gulamdastagir

how can a dataport have more than 50 flowfields for eg iam trying to create a dataport for item table but when i run it it says"you can only add 50 flowfields"

ufuk

No way. 2 dataitem or two separate dataport. I tried something but finally used these

Marije_Brummel

50 flowfields :shock:

Let me see, no, I do not want to see the design of your database. :roll:

I have never experienced this. but maybe you can work with functions and returnvalues, or use variables which you populate.

Good luck.

ufuk

The original Item table has more than 50 flowfields, MS did that

Karenh

I saw that message today. I was also creating an item dataport/

I removed some flowfields from the dataport. and then it worked.

gulamdastagir

Dataports has problems with BLOBS,FLOWFIELDS(>50) the only way to work aroudn teh problem is to create 2 dataports for item table like ufuk said

Marije_Brummel

Hmm, and I still remember the time the limit on running tables was 30 flowfields.

I must be getting old.

David_Cox

The table having over 50 flowfields is one thing, but needing over 50 flowfields in a single dataport is another. :shock:
Why not be more selective in what flowfields you actually need, instead of adding all fields, view the field list then highlight only the fields you want, instead of selecting all, it will then add your selection of fields only.

"Just in Case"
View > Dataport Fields
Click Field List
Select Fields CTRL+Click
Click back on Dataport Fields list
Yes to Append selected Fields to the list

David

gulamdastagir

Thats right it would be better if NAvision had the "field class"i.e flowfield,flowfilter,normal on the "field menu" when you select the DataItem in a dataport

The "field class"is only available from the Table designer as of now but no filters ,pasting in excel and filtering to avoid the flowfields while selcting the fields of a dataport are time consuming.

ara3n

gulamdastagir wrote:

Thats right it would be better if NAvision had the "field class"i.e flowfield,flowfilter,normal on the "field menu" when you select the DataItem in a dataport

The "field class"is only available from the Table designer as of now but no filters ,pasting in excel and filtering to avoid the flowfields while selcting the fields of a dataport are time consuming.

You can put that on your wish list and wait 6 years. I've waited 6 years for getlasterror function.